Only the first mysql_query goes through, rest doesn't...

jeffkee

$sql1 = "INSERT INTO usercars (ID,car) VALUES('$id','1')";
$sql2 = "INSERT INTO usercars (ID,car) VALUES('$id','2')";
$sql3 = "INSERT INTO usercars (ID,car) VALUES('$id','3')";
$sql4 = "INSERT INTO usercars (ID,car) VALUES('$id','4')";
$sql5 = "INSERT INTO usercars (ID,car) VALUES('$id','5')";




mysql_query($sql1);
mysql_query($sql2);
mysql_query($sql3);
mysql_query($sql4);
mysql_query($sql5);

I tried everything. Getting rid of the ' marks before and after teh values, putting the whole thing into one line, and all that.

With this code here, only the first $sql1 statement goes through - the table row is created, but I need 5 rows for each ID generated, and it's just not working properly for some reason. The ID field is an int field, car field is just a VARCHAR field.

THank you.

ahundiak

Are you sure ID is not an UNIQUE column? Try posting the SQL used to create the table.

bubblenut

try replacing your plain calls to mysql_query with

mysql_query($sql1) or die($sql1.':'.mysql_error()."\n");
mysql_query($sql2) or die($sql2.':'.mysql_error()."\n");
//etc...

so that you can see why it's choking. I'm guessing because ID is a unique_id and you're trying to assign the same ID to more than one row in the table.

jeffkee

I dont have the SQL, cause i created it on MyADMIN.

ID is NOT a unique field or anything, I made sure of that. Just an integer field. I already had cases of mutiplelines with same IDs.

jeffkee

never mind, sorry.. stupid mistake.

I got rid of the unique key, but I forget to get rid of the primary, which automaticlaly makes it a unique....

Problem solved, thanks. That was silly eh. haha