SELECT LAST_INSERT_ID()
Posted: Sat Nov 30, 2002 1:56 pm
Arrrggghhhhhhh
I want to get the result back form this query
I am doing error checking to make sure I get a result but I can't figure out how to access that result so I can play with the number that should be returned ex. 17 or what ever the last auto-incremented value is.
Any help is great, other suggestions to.
phpScott
I want to get the result back form this query
Code: Select all
$sql="SELECT LAST_INSERT_ID('sponId') FROM sponsor";
$r=mysql_query($sql);Any help is great, other suggestions to.
phpScott