Page 1 of 1

how can I create automatic code for visitors in mySQL?

Posted: Wed Aug 16, 2006 9:20 am
by prasitc2005
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!

Posted: Wed Aug 16, 2006 9:22 am
by feyd
You were given a function by litebearer.. it could be used here too.

Posted: Wed Aug 16, 2006 9:27 am
by prasitc2005
No, it's a different case this time. I need to know how to do it inside mysql phpmyadmin this time. Just want to do it with sql command like update table something...

Posted: Wed Aug 16, 2006 9:34 am
by feyd
No, it's actually not all that different this time.