Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
02-26-2009, 05:07 PM #1
- Join Date
- Feb 2009
- Thanked 0 Times in 0 Posts
Insert data into two tables using php and mysql
I have two tables called client and booking, the primary key in client table is clientID which is autoincress number and it’s a primary key, in the second table (booking) the primary key is bookingID and its autoincress number and the clientID is foren key.
I have a questions:
How could I get the clientID number from the first table and embedded to a Mysql querry to insert it with the other booking details i.e (arrival date, departure date,...) into the booking table.
Any help will be highly appreciated ( I have read about the last_insert_id() but I don’t know how to use it an example will very good help).
02-26-2009, 10:48 PM #2
- Join Date
- Dec 2005
- Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
- Thanked 637 Times in 625 Posts
http://php.net is your one-stop resource for "how do I" questions on specific PHP functions. The function you want to call is mysql_insert_id().