mymilkshake

Thank you for the reply. How would i explode it? Just take the implode(",",) and replace implode with explode?

[!--quoteo(post=387324:date=Jun 23 2006, 08:17 PM:name=phpstuck)--][div class=\'quotetop\']QUOTE(phpstuck @ Jun 23 2006, 08:17 PM) [snapback]387324[/snapback][/div][div class=\'quotemain\'][!--quotec--] <input type="checkbox" name="features[]" value="Sauna"> is correct how you process it into the database is where you are probably having the trouble. [code] //<?php blah blah would be before the first lines.. $String3a = implode(", ", $_POST['features']); $String3b = implode(", ", $_POST['somethingelse']); $String3c = implode(", ", $_POST['anotherone]); //other stuff might be here $sql = mysql_query("INSERT INTO yourtablename (features, somethingelse, anotherone)                      VALUES('$String3a', '$String3b', '$String3c')")                      or die (mysql_error());   if(!$sql){     echo 'A database error occured while updating your choices. Please contact the Web site owner.';     } else {       include 'nextformpage'; } }   ?> [/code] Hope that helps [/quote] Thank-you, this makes sense. How would I retrieve this information from the database after it is stored? Could I make this information into a table of sorts?

Hello, I have many checkboxes in my form(php) for diffrent selections a user can make. I would like to make them into one array if possible and put it into a mysql table. I have experimented with serialize, unserialize, with no success. I was wondering if someone could point me in the right direction, thanks. echo "<form action=\"post.php\" method=\"post\">\n"; echo "<fieldset>\n"; echo "<legend>\n"; echo "Lister Information\n"; echo "</legend>\n"; echo "<label for=\"listername\">Lister Name(s):</label><input type=\"text\" name=\"listername\"/><br /><br />\n"; echo "<label for=\"listerdayphone\">Lister Day Phone#:</label><input type=\"text\" name=\"listerdayphone\"/><br /><br />\n"; echo "<label for=\"listernightphone\">Lister Night Phone#:</label><input type=\"text\" name=\"listernightphone\"/><br /><br />\n"; echo "</fieldset>\n"; echo "<fieldset>\n"; echo "<legend>\n"; echo "House Information\n"; echo "</legend>\n"; echo "<label for=\"headline\">Headline:</label><input type=\"text\" name=\"headline\" /><br /><br />\n"; echo "<label for=\"price\">Price:</label><input type=\"text\" name=\"price\" /><br /><br />\n"; echo "<label for=\"address1\">Property Address1:</label><input type=\"text\" name=\"address1\" /><br /><br />\n"; echo "<label for=\"address2\">Property Address2:</label><input type=\"text\" name=\"address2\" /><br /><br />\n"; echo "<label for=\"town\">Town:</label><input type=\"text\" name=\"town\" /><br /><br />\n"; echo "<label for=\"province\">Province:</label><select name=\"province\" ><option selected>B.C<option>A.B</select><br /><br />\n"; echo "</fieldset>\n"; echo "<fieldset>\n"; echo "<legend>\n"; echo "Property Description\n"; echo "</legend>\n"; echo "<label for=\"highlight1\">High Light Bullet1:</label><input type=\"text\" name=\"highlight1\" /><br /><br />\n"; echo "<label for=\"highlight2\">High Light Bullet2:</label><input type=\"text\" name=\"highlight2\" /><br /><br />\n"; echo "<label for=\"highlight3\">High Light Bullet3:</label><input type=\"text\" name=\"highlight3\" /><br /><br />\n"; echo "<label for=\"longdescription\">Long Description:</label><input type=\"text\" name=\"longdescription\" /><br /><br />\n"; echo "</fieldset>\n"; echo "<fieldset>\n"; echo "<legend>\n"; echo "House Features\n"; echo "</legend>\n"; echo "<table>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Acerage\" />Acerage</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Farm\" />Farm</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Irrigation\" />Irrigation</td>\n"; echo "\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Landscaped\" /> Landscaped</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Established Fruit Trees\" />Established Fruit Trees</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Fenced\" />Fenced</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Barn\" />Barn</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"RV Parking\" />RV Parking</td>\n"; echo "\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Kennel\" />Kennel</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Storage Shed\" />Storage Shed</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Greenhouse\" />Greenhouse</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Lake View\" />Lake View</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"View\" /> View</td>\n"; echo "\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Waterfront\" /> Waterfront</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Deck\" />Deck</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Balcony\" />Balcony</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Sun Room\" />Sun Room</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Patio\" />Patio</td>\n"; echo "\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Sky Lights\" />Sky Lights</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Vaulted Ceilings\" />Vaulted Ceilings</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Walk-in Closet\" />Walk-in Closet</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"En Suit\" />En Suit</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Pantry\" />Pantry</td>\n"; echo "\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Island Kitchen\" />Island Kitchen</td>\n"; echo "</tr>\n"; echo "<tr>"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Bus Route\" />Bus Route</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Work Shop\" />Work Shop</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Cul de Sac\" />Cul de Sac</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"School Nearby\" />School Nearby</td>\n"; echo "\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"In-Law Suit or Rental Suit\" />In-Law Suit or Rental Suit</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Handicap Access\" /> Handicap Access</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Wood Fireplace\" />Wood Fireplace</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Gas Fireplace\" /> Gas Fireplace</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Built in Vac\" />Built in Vac</td>\n"; echo "\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Air Conditioning\" />Air Conditioning</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Network Wiring\" />Network Wiring</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Security System\" />Security System</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Window Convering Included\" />Window Convering Included</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Built in Speakers\" />Built in Speakers</td>\n"; echo "\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Jetted or Soaker Tub\" />Jetted or Soaker Tub</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Pool\" />Pool</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Hot tub\" />Hot tub</td>\n"; echo "<td><input type=\"checkbox\" name=\"features[]\" value=\"Sauna\" />Sauna</td>\n"; echo "</tr>\n"; echo "</table>\n"; echo "</fieldset>\n"; echo "<input type=\"submit\" value=\"Send\">\n"; echo "</form>\n";