mysql_insert_id problem

paulkenn

I cannot get the following code to work...

It does not appear to be holding the auto-increment value,
I know the problem is with the variable $lastcalc but not sure what,
in variable $insert if I change key to c22 = 'specfic value' it works properly...

$insert = "INSERT INTO calc VALUES ('$c1a','$c1b', '$c2a', '$c2b', '$c3', '$c4', '$c5a', '$c5b', '$c6a', '$c6b', '$c7a', '$c7b', '$c8', '$c9', '$c10', '$c11', '$c12', '$c13', '$c14', '$c15', '$c16', '$c17a', '$c17b', '$c18', '$c19', '$c20', '$c21', '$c22', '$c23', '$c24', '$c25', '$c26', '$c27a', '$c27b', '$c28', '$c29', '$c30', '$c31', '$c32', '$c33a', '$c33b', '$c34', '$c35', '$c36', '$c37', '$c38', '$c39', '$c40', '$c41', '$c42', '$c43a', '$c43b', '$c44', NULL)";

	$lastcalc = mysql_insert_id();

	$result = mysql_query($insert) or die("Query failed");		

	$query = "SELECT * FROM calc WHERE key = '$lastcalc'";
	$result = mysql_query($query) or die("try again");

	$line = mysql_fetch_array($result, MYSQL_ASSOC);

devinemke

you need to call [man]mysql_insert_id[/man] after you run the query. you are calling before.

paulkenn

Okay, I see the logic in that now, however, I'm real new to php coding and I've tried moving the call to mysql_insert_id() after the query but it won't work. How do I code it correctly?
Thanks

mchip

$result = mysql_query($insert) or die("Query failed");

$lastcalc = mysql_insert_id();

$query = "SELECT * FROM calc WHERE key = '$lastcalc'";
$result = mysql_query($query) or die("try again");

$line = mysql_fetch_array($result, MYSQL_ASSOC);