Re: Is there an easier way of doing this?

definitely a loop will do the job. on a form submission, you can get all the submitted fields/ values in $_POST or $_GET array. just, try 'print_r($_POST)', on top of your receiving script. you will realise the scene behind. :) then, get the size of the $_POST array and loop through the array elements. a common data base function to insert the data will ease your life further. ~viraj On 5/10/06, Chris Grigor <chris@youandme.co.za> wrote:

morning all, Is there an easier way of doing the following?? form1 submitting to form1.php <input type="checkbox" name="1"> <input type="checkbox" name="2"> <input type="submit> form1.php <?php $link = mysql_connect('host', 'user', 'pass') or die ("Connection failed:" . mysql_error()); mysql_select_db('yourdbname', $link) or die ("selection failed: " . mysql_error()); if(isset($_POST[1])) {

    mysql_query("INSERT INTO menu (label) VALUES ('item 1 selected')");
    }

else {

    mysql_query("INSERT INTO menu (label) VALUES ('item 1 not selected')");
    }

if(isset($_POST[2])) {

    mysql_query("INSERT INTO menu (label) VALUES ('item 2 selected')");
    }

else {

    mysql_query("INSERT INTO menu (label) VALUES ('item 2 not selected')");
    }

mysql_close($link); ?> So my question is, if I have a form with 20 + items which can be checkboxes, when submitted do I need to go through each one and add it to the datasbase or maybe some kind of loop?. Thank you Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php