for loop and sql queries

[Tandem]

I'm trying to use a for loop to insert records into my database. Here's some theoretical code:

[code]for ($i = 0 ; $i < $num ; $i++) {
$id = mysql_insert_id();
$do_insert = mysql_query("INSERT INTO BLAH (ID) VALUES('$id')");
}[/code]

when i do this, only 1 record is inserted, no matter what the value of $num ($num is always a posive number above 0 btw).

What should i do to make it insert the right numbr of records?

If you don't understand me or need more info just say.

Any help appreciated.

[olegk]

because you are trying to insert identical IDs into the table. I assume ID is the primary key.

[Tandem]

Yes it is. How would you suggest i insert different id's?

[Corona4456]

If your ID field is auto_increment then you don't have to worry about it... don't give it a value and MySQL will do it for you or you can pass it null... as follows:

[code]mysql_query("INSERT INTO BLAH (ID) VALUES (NULL)[/code]

[Tandem]

Ahhh, ok thanks Corona, that's exactly what i needed.

[Corona4456]

No Problem... glad to help :)

[Barand]

Also, you call mysql_insert_id() AFTER the insert to find out the value of the newly allocated id.