Re: [PHP] max unique number

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

RE: [PHP] max unique number

[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...? -- PHP Gener

RE: [PHP] max unique number

[snip] How do i get a unique max number from a mysql table column? [/snip] SELECT MAX(number) FROM table LIMIT 1; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php