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! Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/279317-mysql-multiform-tracking/#findComment-1436658 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.