Insert an array into mysql rows

robert69

Hi, I've seen a few post for this same thing but I can't seem to get it working. What I'm doing is taking a form with check boxes and putting them into an array. Then I'm attempting to INSERT them into the db, one checkbox value per row. Okay, well I've tries 2 ways that I think should work and they only insert the first value. The lower code produces this error "Duplicate entry '0' for key 1" Anyway here is the code I'm trying...

(I'm not trying to use both blocks of code, just one or the other)

// First code
while(list($key,$value)=each($pagetype)){
//echo $value."<br>";//test
$links="INSERT INTO $username_links (links) VALUES ('$value')";
$insert=mysql_query($links,$connection);

}

// Second code attempt
$number=count($pagetype);
for($a=0;$a<$number;$a++){
$links="INSERT INTO $username_links (links) VALUES ('$pagetype[$a]')";
$insert=mysql_query($links) or die(mysql_error());
//echo $pagetype[$a];//test
}
Thanks in advance...Robert

Anon

Just a quick look... It appears your lower code should work, but the error you are getting means that the value cannot be entered into the datase because the column is supposed to be unique. If you drop your index on the "links" table, it should work.

Actually, what is the name of your table? What value is specified for $username_links. If your table were called links, then your SQL should like this:

$links="INSERT INTO links VALUES ('$pagetype[$a]')";

For clarity sakes, you should store your SQL code into $sql instead of $links. Technicaly speaking, the SQL is not actually links; the results of the query are, but not the SQL. But that's just me being nit-picky. I like my code to explain itself, rather than me explaining my code.

AaronZoller.com

If doesn't fly, let me know and I'll strap a whole case of bottle rockets to it's back. Really, I'll look into the code deeper if that doesn't work.

Anon

Thanks for the effort Aaron. I had a darn Unique field in the db. Also, I usually call my query variable $query instead of $sql. You're right though, $links would be bad to edit down the road.

Regards,
Robert

jackansi

Its also a good idea to specify the SQL link that each query uses. Even if you only have one opened link, the minute you want to add a second you'll be doing this step anyway.

Its just another one of those useless steps I take to make sure things work smooth. 🙂