How in the name of cow do you get the next autoindex of a given table in a database, i know it can be done but the PHP Manual isnt helping and the SQL manual is terrible! Anyone have any idea at all?

oh no, figured it out.

Found that you can use LAST_INSERT_ID() to do what i needed, as i wanted to place the ID of something i had added into one table and place it in another related table.

Magic.

and if you want to get the last used ID from any table you can use;


SELECT LAST_INSERT_ID(auto_column) AS alias FROM table ORDER BY auto_column DESC LIMIT 1 ;

That's a good tip chrishirst, I wasn't aware of the last_insert_id() function. That could prove to be very handy.