Inserting Multiple rows in a table

[Anon]

I think I just posted this to the wrong list, so here goes again:

I am trying to insert multiple rows into the same table using the script below. BUT it is only inserting the very first entry and not the second, third, etc. What am I missing? Thanks in advance.

for($count=0;$count<count($i_id);$count++)

{
// Create the order record
$query_insert="INSERT INTO cart (i_id,i_quantity,ordernum) VALUES ('$i_id[$count]','$i_quantity[$count]','$ordernum[$count]')";

if (!($result_insert = mysql_db_query($DB , $query_insert))){
DisplayErrMsg(sprintf("internal error %d:%s\n",
mysql_errno(), mysql_error()));
}

[factory21]

make sure you increment your ID if this is your priimary key. Another way is to set this field up as AUTO_INCREMENT in mysql and to not specify this field when inserting records.