Jump to content

Database and PHP help


leeh14

Recommended Posts

Hi,

 

Just need to know if I am on the right lines, basically I am about to create two tables; one to hold customer information and another to hold information the customer gave me. Both tables will be populated with information that they give me at the same time (in other words from a single form).

 

Just want to know, if I have a field called ID set to a primary key in both the tables, will that be enough to link them both together?

 

Furthermore, what would the mySQL code look like if I wanted to view all the information referencing to specific ID? so info from the customer table and the other.

 

Any and all help would be great.

 

Lee

 

Link to comment
https://forums.phpfreaks.com/topic/216251-database-and-php-help/
Share on other sites

Sorry I was being a fool, i understand that statement now. But it does lead me to anouther question; when adding information for the first time information will go into both tables at the same time, but how will i make sure that the ID number is the same inside both the tables?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.