Hi!
I'm very new to MYSQL.
I'm trying to make a databases of my friend's personal data.
I divide the data into 2 related tables (relational database).
When I tried to get the data out from (both) tables - I don't find any major
problem. However, when I tried to insert data into both table.. I find
difficulties.
What I want is to insert data which is from an html form page into both
tables. As a note in relational tables there is a field which is the same.
for example:
table1:
FIRST_NAME | LAST_NAME
Ardani | Sarjito
Budi | Raharjo
etc...
table2:
LAST_NAME | PHONE
Sarjito | 1111111
Raharjo | 2222222
etc...
now-> I How do I insert the third data into both tables? (do I have to
insert the data one by one or ...???)
If I insert the data one by one, I think there will be a chance of doubling
the data.
Any comment or help would be greatly appreciated.
Ardani
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php