Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
getting an id from one table, placing in another
Thank you KarveR, you are my favourite person today! That code has been bothering me for days. thankyouthankyouthankyou Michelle -
getting an id from one table, placing in another
Thanks KarveR, I was a little suspicious of that newid variable being inserted into the table...so I fixed that. So what my code looks like now: $SQL = "INSERT INTO document (title) VALUES ('$title')"; $newid= mysql_insert_id(); mysql_query($SQL); printf... -
getting an id from one table, placing in another
Hi, Relatively new to the PHP/MySQL world, hoping you can help. I have built a database and I am having trouble grasping one little part. I need to get the id that is a primary key, auto increment, in one table (document) and put it into another table(key_doc_join) as the data is being entered...
