I have a form that asks customers which of 42 categories they are interested in. I have created three tables to handle the results. Everything writes to the pf_survey table with no problems and only the first checkbox selected writes to the cat_survey table. What am I missing? Is it something in my code or do I need to do something special to my cat_survey table? Thanks.
pf_survey Survey_id,Ques,date etc cat_survey Survey_id, category_id Categories Category_id, category_name Here is the code <?php $protected=1; include "header.php"; $perm->check('admin'); $username = $auth->auth["uname"]; $_POST['category_id']; if ($Submit) { $res=mysql_query("insert into pf_survey (customer_number,interest_pf,return_call,call_date,comments,submit_time, username) values ('$customer_number','$interest_pf','$return_call','$call_date','$comment s',now(),'$username')",$dbi); if (!$res) { print "<p>Couldn't insert your record: ".mysql_error()."</p>\n"; } $pfsurvey_id=mysql_insert_id($dbi); $this->pfsurvey_id=$pfsurvey_id; $numcat = count($category); if ($numcat>1){ $category_id=implode(",",$category); } elseif ($numcat==1){ $category_id=$category; } $cat=mysql_query("insert into cat_survey (pfsurvey_id, category_id) values ('$pfsurvey_id','$category_id')",$dbi); if (!$cat) { print "<p>Couldn't insert your record: ".mysql_error()."</p>\n"; } print "<p>Loaded your data correctly.</p>\n"; print "<p><a href=pf_survey.php>Add another record.</a></p>\n"; } else { ?> <form action="<?php print $sess->self_url(); ?>" method="post"> <?php $sess->hidden_session(); ?> <div align="left"> <p>Customer Number <input type="text" name="customer_number" size="6" maxlength="6"> (look on catalog for label with number)<br> <br> 1. Are you interested in Power Forward? Yes <input type="checkbox" name="interest_pf" value="Y"> No <input type="checkbox" name="interest_pf" value="N"> <br> 2. Would you like for us to call back? Yes <input type="checkbox" name="return_call" value="Y"> No <input type="checkbox" name="return_call" value="N"> Date to call back (yr-mm-dd) <input type="date" name="call_date" maxlength="10" size="12"> </p> <p>In which of the following categories are you interested?<br> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td > Air Compressors <input type="checkbox" name="category[]" value="1"> <br> Air Tools <input type="checkbox" name="category[]" value="2"> <br> Animal Traps <input type="checkbox" name="category[]" value="3"> <br> Apparel-Work Clothing <input type="checkbox" name="category[]" value="39"> <br> Bending Brakes <input type="checkbox" name="category[]" value="4"> <br> Blades <input type="checkbox" name="category[]" value="42"> <br> Brick Tools <input type="checkbox" name="category[]" value="38"> <br> Business Supplies <input type="checkbox" name="category[]" value="26"> <br> Carpet & Drying <input type="checkbox" name="category[]" value="5"> <br> Concrete <input type="checkbox" name="category[]" value="6"> <br> Detail Shop <input type="checkbox" name="category[]" value="41"> <br> Drain Cleaners <input type="checkbox" name="category[]" value="7"> <br> Drilling & Boring <input type="checkbox" name="category[]" value="8"> <br> Dry Wall Tools <input type="checkbox" name="category[]" value="9"> </td> <td>Engines & Motors <input type="checkbox" name="category[]" value="10"> <br> Floor Maintenance Tools <input type="checkbox" name="category[]" value="11"> <br> Generators <input type="checkbox" name="category[]" value="12"> <br> Heaters <input type="checkbox" name="category[]" value="13"> <br> Lawn & Garden <input type="checkbox" name="category[]" value="15"> <br> Lighting <input type="checkbox" name="category[]" value="40"> <br> Magnetic Tools <input type="checkbox" name="category[]" value="16"> <br> Marine Propellers <input type="checkbox" name="category[]" value="37"> <br> Material Handling <input type="checkbox" name="category[]" value="17"> <br> Nailers & Supplies <input type="checkbox" name="category[]" value="18"> <br> Painters & Supplies <input type="checkbox" name="category[]" value="19"> <br> Party <input type="checkbox" name="category[]" value="21"> <br> Pipe Threaders <input type="checkbox" name="category[]" value="22"> <br> Power Tools & Blades <input type="checkbox" name="category[]" value="23"> </td> <td valign="top" >Pressure Washers <input type="checkbox" name="category[]" value="24"> <br> Pumps & Hoses <input type="checkbox" name="category[]" value="25"> <br> Roofing <input type="checkbox" name="category[]" value="27"> <br> Safety <input type="checkbox" name="category[]" value="28"> <br> Scaffolding & Accessories <input type="checkbox" name="category[]" value="29"> <br> Shop Tools <input type="checkbox" name="category[]" value="30"> <br> Surface Preparation <input type="checkbox" name="category[]" value="32"> <br> Surveying <input type="checkbox" name="category[]" value="33"> <br> Steel & Carbide <input type="checkbox" name="category[]" value="31"> <br> Trailer & Towing <input type="checkbox" name="category[]" value="34"> <br> Ventilation <input type="checkbox" name="category[]" value="35"> <br> Welding <input type="checkbox" name="category[]" value="36"> </td> </tr> </table> <br> Additional Comments: <br> <textarea name="comments" cols="60" rows="4"></textarea> <br> </div> <p align="left"> <input type="submit" name="Submit" value="Submit"> <br> </p> <div align="left"> Thank you for your time!<br> Visit our website at www.mtadistributors.com </div> </form> <?php } ?> <?php include "footer.php"; ?> Duffy Betterton Director of Publications 615-277-3265 [EMAIL PROTECTED] www.mtadistributors.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php