PHP MYSQL id

[woody79]

i have a table with the primary key as id and i want the php script to insert values into the table but with a random 6 digit number. the problem i have is that if php randomly selects a number that is already in the table the values won't be entered. if youre wondering it is a confidentiality thing otherwise i would just use auto_increment

[jitesh]

INSERT IGNORE INTO `....`  ( ... ..... ..... ) VALUES ( .. .. . .. ....)

[trq]

the problem i have is that if php randomly selects a number that is already in the table the values won't be entered.

 

So, check to make sure the value doesn't allready exist before running the insert query. If it does exist, create another id.

[woody79]

INSERT IGNORE INTO `....`  ( ... ..... ..... ) VALUES ( .. .. . .. ....)

??? that went stright over my head

 

So, check to make sure the value doesn't allready exist before running the insert query. If it does exist, create another id.

Thanx but how would i do that