RE: [PHP] Insert an array into MySQL

Your second method should work, but it's dependent on what your form looks like and how your table was created. You obviously have a key set for this column and you're trying to insert the same value twice, which makes an error. Show us what your form looks like, not the whole thing, just for the checkboxes. Also, what does your CREATE TABLE look like for the table your trying to insert this data into? ---John Holmes... > -----Original Message----- > From: Rob Packer [mailto:robert@nrc.net] > Sent: Sunday, June 23, 2002 7:50 AM > To: php-general@lists.php.net > Subject: [PHP] Insert an array into MySQL > > 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. They both produce this error "Duplicate entry '0' for key > 1" (which I don't understand) 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 > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php