dynamic insert statement

Anon

need help with php-mysql, dynamic insert statement

.. the code is as follows

<?
$sql = "INSERT INTO test(id) values ";
for($i=1;$i<=10;$i++) {
$sql.="($i)";
if($i!=10) {
$sql.=',';
}
}
$db_insert = mysql_query($sql,$connection)

or mysql_error();
?>

the above statement is not inserting any records ..

the insert statement i am using is correct .. also

checked with printing the sql statement .. syntax

everything is fine ... and not giving any mysql

error ...

whats going wrong?

Raghu.

Anon

No, it doesn't look like it's producing a correct statement... from looking, it seems like you'll get a query that looks like:

INSERT INTO BLAH VALUES (1) (2) (3) ... (10),

You need to have a separate insert statement for each row you're inserting...

INSERT INTO BLAH VALUES (1);
INSERT INTO BLAH VALUES (2);