Samuel Cochran wrote:
Evan Barter wrote:
Samuel Cochran wrote:
Mike Fewings wrote:
Unfortunately I don't know any function in MySQL that lets you retrieve the auto-increment ID of a field you just created. You normally have to do another select, which is not hard if you do this: "SELECT ID FROM Artists ORDER BY ID DESC LIMIT 1" This will give you the last created ID, which normally would be the last record you created.
This function can retreive the last insert id from the database
select last_insert_id() as feild_id
and make this query immediately after the insert and it will return the last id that was inserted by auto increment.
Alternatively, one can use the mysql_next_id() function of PHP. Have a look: http://php.net/mysql-next-id
There's always mysql_insert_id() (http://au.php.net/manual/en/function.mysql-insert-id.php). But now I'm just being redundant. :)
That's what I meant :$
-- Sam
_______________________________________________ PHPwestoz mailing list PHPwestoz@lists.linux.org.au http://lists.linux.org.au/listinfo/phpwestoz
Another way of doing this could be:
Select max(id) from table_name
--SimonM