SQL "LAST" Function

[supertrucker]

Here's my code

 SELECT LAST(LinkId) FROM waplinks WHERE SubmitterId='1'

This code generates a syntax error, but doesn't tell me what I did wrong...

[homiee]

trySELET MAX(LinkId) as LastLinkId FROM waplinks WHERE SubmitterId='1'

[supertrucker]

Thanks for your help! I also found this in the PHP SQL functions, that does exactly what I needed:

 $linkid=mysql_insert_id();

Returns the unique id of the last insert row.