J
jeremyjcochran
Guest
I want one form to submit to 3 different tables in MYSQL... I got them to submit to the right tables, but I want to take the first tables id (primary key, auto_increment) and make that the realtor_id of the other two tables. Anyone know what I need to put in the field of the other 2 to make it read it properly? Heres what I have so far...
if($_POST['submit'])
{
$sql = "INSERT INTO logins (username, password) VALUES('" . $_POST['usernameBox'] . "', '" . $_POST['passwordBox'] . "');";
mysql_query($sql);
$realtorsql = "INSERT INTO realtors (realtor_id, first_name, last_name, address, city, state, zip, email, phone, cell, fax) VALUES( '" . $sql['id'] . "', '" . $_POST['firstnameBox'] . "', '" . $_POST['lastnameBox'] . "', '" . $_POST['addressBox'] . "', '" . $_POST['cityBox'] . "', '" . $_POST['stateBox'] . "', '" . $_POST['zipBox'] . "', '" . $_POST['emailBox'] . "', '" . $_POST['phoneBox'] . "', '" . $_POST['cellBox'] . "', '" . $_POST['faxBox'] . "');";
mysql_query($realtorsql);
$websitesql = "INSERT INTO realtors_websites (realtor_id, main_title) VALUES('" . $sql['id'] . "', '" . Welcome . "');";
mysql_query($websitesql);
header("Location: " . $config_basedir . "realtorwelcome.php");
}
-----------------------------------
Obviously '" . $sql['id'] . "' doesn't work, what would I use instead? Or should I make the first page just username/ pass and next page it loads up the additional information, but I don't know how to get it to read the new id formed in that scenario either. Thank you!
if($_POST['submit'])
{
$sql = "INSERT INTO logins (username, password) VALUES('" . $_POST['usernameBox'] . "', '" . $_POST['passwordBox'] . "');";
mysql_query($sql);
$realtorsql = "INSERT INTO realtors (realtor_id, first_name, last_name, address, city, state, zip, email, phone, cell, fax) VALUES( '" . $sql['id'] . "', '" . $_POST['firstnameBox'] . "', '" . $_POST['lastnameBox'] . "', '" . $_POST['addressBox'] . "', '" . $_POST['cityBox'] . "', '" . $_POST['stateBox'] . "', '" . $_POST['zipBox'] . "', '" . $_POST['emailBox'] . "', '" . $_POST['phoneBox'] . "', '" . $_POST['cellBox'] . "', '" . $_POST['faxBox'] . "');";
mysql_query($realtorsql);
$websitesql = "INSERT INTO realtors_websites (realtor_id, main_title) VALUES('" . $sql['id'] . "', '" . Welcome . "');";
mysql_query($websitesql);
header("Location: " . $config_basedir . "realtorwelcome.php");
}
-----------------------------------
Obviously '" . $sql['id'] . "' doesn't work, what would I use instead? Or should I make the first page just username/ pass and next page it loads up the additional information, but I don't know how to get it to read the new id formed in that scenario either. Thank you!