get last nember after insert

[alirezaok]

i hava a autoincrement integer field. u know when i run command
insert to table value ('0')
it add +1 digit after last digit that there is end of records as record.
i want to know which number will be added after i run this command.
one way is after this command i run
SELECT * FROM table ORDER BY id DESC LIMIT 0 , 1
to get last nember that added
but is there better soloution or with php?
Thanks

[tweek]

assuming your using mysql then

mysql_insert_id()

http://uk.php.net/mysql_insert_id