last_insert_id() question?

[coder9]

hi

 

i use the LAST_INSERT_ID(), is this query correct?

 

$query = "SELECT * FROM jtablegrid WHERE game_no = LAST_INSERT_ID()"; 

 

 

thank you.

[Dethman]

$query = "SELECT * FROM jtablegrid WHERE game_no = LAST_INSERT_ID()";

 

should be

 

$query = "SELECT * FROM `jtablegrid` WHERE `game_no` = LAST_INSERT_ID()";

[TempleDMDKrazd]

hi

 

i use the LAST_INSERT_ID(), is this query correct?

 

$query = "SELECT * FROM jtablegrid WHERE game_no = LAST_INSERT_ID()"; 

 

 

thank you.

 

assuming jtablegrid.game_no is on auto_increment then yes, its correct.

[JasonLewis]

What's last_insert_id(), I've never heard of it. I've heard of mysql_insert_id() though.

 

Don't make it in uppercase as well, all lowercase.

 

So it should be this:

$query = "SELECT * FROM `jtablegrid` WHERE `game_no`='".mysql_insert_id()."'";