Hi guys, I am trying to capture data from my form and pump it into a database, but when I try to input data into a column, I only get the uid, and the rest of the columns are empty.
Here is some code:
mysql_query("INSERT INTO personal_information (uid, name, surname, email, cell)
VALUES ('".$uid."', '".$name."', '".$surname."', '".$email."', '".$cell."' )")
or die(mysql_error());
mysql_query("INSERT INTO consumer_related_info (uid)
VALUES ('".$uid."')")
or die(mysql_error());
mysql_query("INSERT INTO family_scenario (uid)
VALUES ('".$uid."')")
or die(mysql_error());
mysql_query("INSERT INTO lifestyle_activities (uid)
VALUES ('".$uid."')")
or die(mysql_error());
mysql_query("INSERT INTO occupational_information (uid)
VALUES ('".$uid."')")
or die(mysql_error());
mysql_query("INSERT INTO sport_activities (uid)
VALUES ('".$uid."')")
or die(mysql_error());
mysql_query("INSERT INTO vehicle_details (uid)
VALUES ('".$uid."')")
or die(mysql_error());
What could I be doing wrong?