help with mysql_insert_id();

[jcjst21]

Hello,

 

I used the mysql_insert_id() command on another script i wrote, and it worked fine.

I pretty much reused the same code on another script for another table and it doesn't seem to be working.

 

Here is my code:

$sql="INSERT INTO AllergyList(camperID, camperAllergy) VALUES ('$camperID', '$allergy')";
$result = mysql_query($sql,$con);
$allergyID=mysql_insert_id();

$sql2="INSERT INTO camperAllergyReactions(camperAllergyID, camperAllergyReaction) VALUES ('$allergyID', '$reaction')";

 

the first INSERT statement populates the data fine into the Allergy table, but the mysql_insert_id() does not seem to be working in this script.

 

Any help would be appreciated.

 

Thanks,

jcjst

[phpSensei]

Print out a mysql_error() and let me know what it says.

[jcjst21]

I actually had a header statement right after the second insert function and had it before the fetch query.

That's what was holding it up.

 

I figured it out.

 

 

[phpSensei]

Roger.

 

Marked as solved I guess..