@@identity? 1

[hads]

Hi all,

I'm brand new to MySQL (used to MSSql using ASP) I'm trying to move in the open source direction so I'm converting one of my ASP/MSSql apps to PHP and MySQL.

Anyway, in this app I use a SELECT @@Identity on the end of a query to get the autonumber of a record that was just inserted. Can someone give me a shove in the right direction as to how I go about doing this with MySQL?

Cheers.

01101000011000010110010001110011

 

[danielhozac]

If you want to use the PHP way of doing it, mysql_insert_id() is the way to go. Like this
mysql_query("INSERT INTO table VALUES (NULL, 'blah')"
$id = mysql_insert_id();
MySQL's function of doing it is LAST_INSERT_ID(). //Daniel

 

[hads]

Cool,

Cheers for that, that gives me something to work with.


01101000011000010110010001110011