Getting primary key from new row

[kwdelre]

If I am using this:

 

mysql_query("INSERT INTO M1QuizResults
		(Email, Q1Choice, Q2Choice, Q3Choice, Score, Pass, Date_Taken, Time_Taken) 
		VALUES(' " . $_SESSION['Email'] . " ', '$QChoice_1', '$QChoice_2', '$QChoice_3', '$Score', '$Pass', CURDATE(), NOW())")

		 or die(mysql_error());

 

What would I use to find out what the row's "Id" is? "Id" is my primary key. I want to store this "Id" as a session variable. thanks!

[Rifts]

cant you just do mysql_query("select id from m1quizresults where email = session['email'] ")

 

obviously fix syntax

[inversesoft123]

$currdate = CURDATE();
$now = NOW();
mysql_query("INSERT INTO M1QuizResults
         (Email, Q1Choice, Q2Choice, Q3Choice, Score, Pass, Date_Taken, Time_Taken)
         VALUES(' " . $_SESSION['Email'] . " ', '$QChoice_1', '$QChoice_2', '$QChoice_3', '$Score', '$Pass', $currdate, $now)")
         
          or die(mysql_error());
$selectlastid=mysql_fetch_array(mysql_query("SELECT id from M1QuizResults WHERE Date_Taken = '$currdate' AND Time_Taken='$now'"));
echo $selectlastid[0];

[PFMaBiSmAd]

No extra query is needed - mysql_insert_id

 

[kwdelre]

No extra query is needed - mysql_insert_id

 

Wow that was easy...thank you so much for your help everyone.