Hi everyone:

I've been fiddling with this all day, and well - if it was working you wouldn't be 
reading this right now! ;-)
My script should take the selections made by users and process them via 
straightforward MySQL inserts:

//Get all table column names, dynamically display them as checkboxes. Use to process 
$fields = mysql_list_fields("$dbName", "myanet_categories", $connect);
$columns = mysql_num_fields($fields);
for ($i=0; $i<$columns; $i++) {
        $names = mysql_field_name($fields, $i) . "\n";
        $catselect .= "<b>$names </b><input type=\"checkbox\" 
name=\"category[$names]\" value=\"yes\"><br>\n";

//If submit button selected, process those ticked checkbox categories:
if(isset($submit)) {
        //loop while categories have been ticked
        for($i=0;$i<count($category);$i++) {
                if($HTTP_POST_VARS["category{$i}"] == 'yes') { //Not sure about this 
                        $sql = "INSERT INTO $myanet02 
                        //$query = mysql_query($sql,$connect) or die(mysql_error());
                        echo $sql;

At the moment not even echoing my $sql works. I know this aint gonna work as it is, 
because what I really need to know is:

* How do I insert into only those categories that have been checked? (default is 
'null' in a VARCHAR(50) field)
* How do I only declare '$email' a single time as this is the only value being 

Many thanks:

  "Believe nothing - consider everything"       
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  w: www.apu.ac.uk/webteam


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to