mysql_insert_id() not working
Posted: Wed Feb 01, 2012 10:04 am
The following INSERT query has an auto_increment field as a primary key. The update DOES take place but the result of mysql_insert_id() is always 0. Any clues why zero?
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