•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 401,495 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,170 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 573 | Replies: 3
 |
•
•
Join Date: Mar 2008
Posts: 22
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
hi all experts here, i am currently doing my web project using PHP and facing no clue for the database connection between 3 tables....here it is:
i'd created 3 tables, one keeps users' username, password, and id....the other keeps the details that user input from a form...both contain a common username. How can i connect both the table and retrieve (SELECT * from ...... ) the whole row of data for the same username? thanks...
i'd created 3 tables, one keeps users' username, password, and id....the other keeps the details that user input from a form...both contain a common username. How can i connect both the table and retrieve (SELECT * from ...... ) the whole row of data for the same username? thanks...
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,218
Reputation:
Rep Power: 10
Solved Threads: 270
You need a primary key (sometimes secondary key is usefull but your DB is small so no need) by which you can assosiate data between tables. So if your user table has an UNIQUE ID you should use that in other tables and this way you can link the data between them
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,218
Reputation:
Rep Power: 10
Solved Threads: 270
I do not think he wants to join 3 tables together, I believe eparse wants to associate data from each table
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
access advice breach broadband business code combo crime css cult of the dead cow daniweb data data protection data transfer database div drive dropdownlist encryption europe forensic forensics fun google hacking hard hardware help hitachi hp html industrial espionage it linux module net news payment services privacy protection reuse search security storage symantec tables terabyte tv web wikipedia
- Previous Thread: is my code correct?
- Next Thread: Help building database
