generating unique number

unique number, php, no same value in database

[freshfromseo]

hello,

does anyone know on how to generate a unique number like for example an employee id or student id. that id is unique right, and it doesnt have the same value in the database. please teach me how...tnx

[phparion]

$c = uniqid (rand (),true);
echo $c;

[freshfromseo]

tnx, but the output is too long. i want to limit the number in 6 digits.

how to do that? please help..

[camilord]

$randNum = uniqid(rand(100000,999999),true);

[camilord]

<?php

$randNum = rand(100000,999999);
echo $randNum;

?>

[whoisgregg]

If you set an auto incrementing field in your database, you can just do an insert (with that value set to null) then use mysql_insert_id() [php.net] to find out what number was assigned by MySQL.