Philip Hallstrom wrote: >> [snip] >> How do i get a unique max number from a mysql table column? >> [/snip] >> >> SELECT MAX(number) FROM table LIMIT 1; > > That might not be unique though... I'm wondering if the original poster > is looking for AUTO_INCREMENT (ie. sequences) to ensure a unique id to > use for insertion...? >
mysql_insert_id() should do the trick for an automatically incremented sequence. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
