Assigning random ID's

[doddsey_65]

How would I assign a random ID to a new user rather than having an AI in the database?

[leehanken]

Don't know what an AI is.

 

See http://php.net/manual/en/function.uniqid.php

 

[ddubs]

I think he means Auto Increment. The nice thing about auto increment is you have no chance of running into duplicates. A rand() function will have some possibility of generating the same value twice.

[Zane]

The nice thing about auto increment is you have no chance of running into duplicates. A rand() function will have some possibility of generating the same value twice.

QFT..

 

Why would you want random IDs in the first place? What's wrong with the regular way?

 

But if you did prefer random IDs, the best route would be to propagate about 1000 or so "empty" entries to begin with.. and then run a SELECT RAND() WHERE NOT EMPTY type query...when you create a new user..

[TeddyKiller]

$id = rand(1, 9999999);

Then use that to insert into database..

Though problem with this.. ID's can be duplicated, which isn't safe.