Code: Select all
$q = "INSERT INTO maaMembers
(last_name,first_name, middle_init, address, city, zip, phone, cell,email,State, registration_date) VALUES ('$ln','$fn', '$mi','$address','$city','$zip', '$phone','$cell','$e','$state', NOW())";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));
echo "ID of last inserted record is: " . mysql_insert_id(); //result is always 0