Nevermind, I got it. I had Unique for a field which made it mad.
"Rob Packer" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > oops, sorry about the other post (I've got a baby that likes the > keyboard)... > > Hi, > > This is the form, which I had doubts about, but it seemed to put things into > the array correctly when I tested it by printing it out. > I can't see how, it will print > key=0 > value=index.html > key=1 > value=about.html > key=2 > value=whats_new.html > when I test it and then have a duplicate key. It's saying that I have 2 > $pagetype[0] correct? Anyhow, here's the form... > > <INPUT TYPE=hidden NAME=pagetype[] VALUE='index.html'>Home Page <br> > <INPUT TYPE=checkbox NAME=pagetype[] VALUE='about.html'>About Page <br> > <INPUT TYPE=checkbox NAME=pagetype[] VALUE='whats_new.html'>What's New > Page<br> > <INPUT TYPE=checkbox NAME=pagetype[] VALUE='contact.html'>Contact Page<br> > <INPUT TYPE=checkbox NAME=pagetype[] VALUE='favorite_links.html'>Favorite > Links <br> > > > The CREATE TABLE is this: > I define the table name from user input. > > $query_links="CREATE TABLE $username_links (id INT(4) not null, links > VARCHAR(20) not null, UNIQUE (id))"; > if(mysql_query($query_links,$connection)){ > echo "Links table created!<br>"; > }else{ > echo "no links table made<BR>"; > } > > > > > thanks, > Rob > > > > > "John Holmes" <[EMAIL PROTECTED]> wrote in message > 001201c21ab5$0df073a0$b402a8c0@mango">news:001201c21ab5$0df073a0$b402a8c0@mango... > > 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:[EMAIL PROTECTED]] > > > Sent: Sunday, June 23, 2002 7:50 AM > > > To: [EMAIL PROTECTED] > > > 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 > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
