Colton.Wagner Posted June 18, 2013 Share Posted June 18, 2013 Hello, So I am having a bit of an issue with some forms I am working with. Let me first descirbe the issue at hand then we will get to my request for help. So I have 3 tables set up with roughly 120 columns. Not all of these columns will contain data as it is based on users entry. Basically what I am trying to do is have the id from the first table match that of the second and third. The script is hit and miss right now by using the mysql_insert_id() function. I would like to let these databases manage themselves and correlate there id's so all three forms can be queried by user id. I thank you for all of your time in advanced hope you can be of assistance! Link to comment https://forums.phpfreaks.com/topic/279317-mysql-multiform-tracking/ Share on other sites More sharing options...
ginerjm Posted June 18, 2013 Share Posted June 18, 2013 Hard to help when you don't ask a specific question. Assuming that you are talking about coordination of the id on all 3 tables - your use of the MySQL_insert_id function gets you a key value; use it to set values in the other two tables which are NOT auto-increment fields. BTW - you do know that MySQL-*** functions are deprecated in php and should be avoided for all new development. Link to comment https://forums.phpfreaks.com/topic/279317-mysql-multiform-tracking/#findComment-1436658 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.