Re: Generate random unique IDs

[Matt Kelley]

Why not just add a unique ID every time a row is added? To be safe, just set the unique ID first, and check the table to make sure that there are no other rows containing that same unique ID (with an 8-digit ID it shouldn't be too grand of a problem, depending on how many rows you are planning on adding with unique IDs)

to check, just use the SELECT * FROM table WHERE unique_ID = '$yourGeneratedID' statement inside a mysql_num_rows() function.

If the result is 0, that means there aren't any rows containing that ID so it's safe to use, obviously.