how can I create automatic code for visitors in mySQL?
Posted: Wed Aug 16, 2006 9:20 am
Hi all MySQL gurus
I have a MySQL table with column name called registration code.
How can I use php script to automaticly create 8-digit unique registration numbers for each visitor name and e-mail address. They won't repeat themseves and not in obvious order like 12345678
column names are
id name e-mail address password registration code
1 yan yan&gmail.com 1234 72145320
2 top top@yahoo.com xvbt 88653421
Thanks!
I have a MySQL table with column name called registration code.
How can I use php script to automaticly create 8-digit unique registration numbers for each visitor name and e-mail address. They won't repeat themseves and not in obvious order like 12345678
column names are
id name e-mail address password registration code
1 yan yan&gmail.com 1234 72145320
2 top top@yahoo.com xvbt 88653421
Thanks!