PHP - How To Make Unselected Checkbox Destroy Previous Array On Update

Hi I have an update page with multipule drop down menus,  I am looking for a way to allow only the drop down menus that have been altered to be sent to the database.  One way was to add the following code, where the $type_id equals 0 then add nothing to the database.

Code: [Select]
if ($type_id == 0) 
{
$type_id = "";
}

However I am getting a syntex error with this,  if I enter a value into the $type_id it selects that fine.  eg.

Code: [Select]
if ($type_id == 0) 
{
$type_id = "2";
}

What is the right way to send nothing to the database?

Fuller code of the page is here

<?php require_once("includes/sessions.php"); ?>
<?php require_once("includes/connections.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php confirm_logged_in();?>
<?php usersid(); ?>
<?php find_selected_event();
     find_selected_region();
     ?>
<?php $selected_event = getevent_byid ($url_eventid);
     $orgdescrip = orgdescription($url_eventid);
     $leveldescrip = leveldescription($url_eventid);
     $typedescrip = typedescription($url_eventid);
     $champdescrip = champdescription($url_eventid);
     $disdescrip = disdescription($url_eventid);
     $venuedescrip = venuedescription($url_eventid);
     $statusdescrip = statusdescription($url_eventid);
?>
<?php if (!isset($new_event)) {$new_event = false;} ?>
<?php
   // make sure the subject id sent is an integer
   if (intval($_GET['url_eventid']) == 0) {
      redirect_to('controlpanel.php');
   }

   include_once("includes/form_functions.inc.php");

   // START FORM PROCESSING
   // only execute the form processing if the form has been submitted
   if (isset($_POST['submit'])) {
      // initialize an array to hold our errors
      $errors = array();
   
      // perform validations on the form data
      
      $required_fields = array('title');
      $errors = array_merge($errors, check_required_fields($required_fields, $_POST));
      
      $required_numberfields = array();
      $errors = array_merge($errors, check_number_fields($required_numberfields, $_POST));
      
      $fields_with_lengths = array();
      $errors = array_merge($errors, check_max_field_lengths($fields_with_lengths, $_POST));
      
      // clean up the form data before putting it in the database
      
      
      $url_eventid = mysql_prep($_GET['url_eventid']);
      $user_id = mysql_prep($_POST['user_id']);
      $title = trim(mysql_prep($_POST['title']));
      $event_details = mysql_prep($_POST['event_details']);
      $type_id = mysql_prep($_POST['type_id']);
      $champ_id = mysql_prep($_POST['champ_id']);      
      $dis_id = mysql_prep($_POST['dis_id']);
      $org_id = mysql_prep($_POST['org_id']);
      $venue_id = mysql_prep($_POST['ven_id']);
      $level_id = mysql_prep($_POST['level_id']);
      $status_id = mysql_prep($_POST['status_id']);
      
      if ($type_id == 0) 
      {
      $type_id = "";
      }
      // Database submission only proceeds if there were NO errors.
      if (empty($errors)) {
         
         $sql = "UPDATE events SET \n"
               . "title = '{$title}',\n"
               . "event_details = '{$event_details}',\n"
                . "type_id = {$type_id},\n"
               . "champ_id = {$champ_id},\n"
               . "dis_id = {$dis_id},\n"
               . "org_id = {$org_id},\n"
               . "ven_id = {$venue_id},\n"
               . "user_id = {$url_userid},\n"
               . "level_id = {$level_id},\n"
               . "status_id = {$status_id}\n"
               . "WHERE event_id = {$url_eventid} \n"
               . "LIMIT 1";


      if ($result = mysql_query($sql, $connection)) {
            // as is, $message will still be discarded on the redirect
            $message = "The event was successfully updated.";
            // get the last id inserted over the current db connection
            $new_event_id = mysql_insert_id();
            redirect_to("newevent.php");
         } else {
            $message = "I am sorry but the event could not be updated.";
            $message .= "<br />" . mysql_error();
         }
      } else {
         if (count($errors) == 1) {
            $message = "There was 1 error in the form.";
         } else {
            $message = "There were " . count($errors) . " errors in the form.";
         }
      }
      // END FORM PROCESSING
   }
   
?>

<?php   /*THIS CODE WITH RETURN IN THE BROWSER THE URLS THAT ARE BEING
      PULLED DOWN*/

if(empty($_GET))
    echo "No GET variables";
else
    print_r($_GET);

?>
<?php include("includes/header.inc.php"); ?>
<title>Horse Events</title>
<?php include_once("includes/meta.inc.php");?>
<?php include_once("includes/cssfavgoogle.inc.php");?>
<link href="css/adminpanel.css" rel="stylesheet" type="text/css" />
<style>
input[type="number"] {
   width:40px;
}
</style>
</head>
<body>
<div id="wrapper">
<div id="header">
<img src="images/horseevents_wheretogo.png" align="right" />
<?php require_once ("includes/adminmenu.inc.php"); ?>
   
</div>
   
    <div id="adminleft">
      <h2>YOUR UPCOMING EVENTS
      <?php echo "<a href=\"newevent.php?url_userid={$url_userid}\"><img src=\"images/pink/add_event.png\" align=\"right\" width=\"131\" height=\"19\" /></a>" ?></h2>       
    <table id="datetable" width="300" border="0" >
    <?php   
        $event_users_set = get_upcomingeventsforuser ($url_userid);
        while ($eventid = mysql_fetch_array ($event_users_set)){
        echo"<tr class=\'date\'>";
        echo"<td>" . $eventid["stdate"] ."</td>";   
        echo"<td><a href=\"editevent.php?url_userid={$url_userid}&url_eventid=". urlencode ($eventid['event_id']) . "\">". $eventid ['title'] . "</td>";
        echo"</tr></a>";
        }
   ?>
   </table>
    <br />
          <h2>YOUR PAST EVENTS</h2>       
    <table id="datetable" width="300" border="0" >
    <?php   
        $event_users_set = get_pasteventsforuser ($url_userid);
        while ($eventid = mysql_fetch_array ($event_users_set)){
        echo"<tr class=\'date\'>";
        echo"<td>" . $eventid["stdate"] ."</td>";   
        echo"<td><a href=\"editevent.php?url_userid={$url_userid}&url_eventid=". urlencode ($eventid['event_id']) . "\">". $eventid ['title'] . "</td>";
        echo"</tr></a>";
        }
   ?>
   </table>
    </div>
    <div id="admincontent">
    <span class="h1pln">Edit Your Event</span><a class="delete" href="deleteevent.php?url_eventid=<?php echo $url_eventid; ?>" onClick="return confirm('Are you sure you want to delete?')">Delete</a><br />
    <span class="h3pln">Please make sure you complete all the compulary fields<span class="compuls">*</span>.<br />
 The more accurately you enter your event the more people will be able to then find it.  <br />
<br />
If there are any selections we do not currently have available please click here and I will add them to your drop down menus.</span>
       <?php if (!empty($message)) {echo "<p class=\"message\">" . $message . "</p>";} ?>
      <?php if (!empty($errors)) { display_errors($errors); } ?>
<form id="newevent" action="editevent.php?url_eventid=<?php  echo urlencode ($selected_event ['event_id']); ?>" method="post">
      <table id="neweventdisplay" cellpadding="5" width="400" border="0">
   <tr>
  <td><input type="text" name="event_id"  value="<?php echo $url_eventid; ?>" /></td>
  <td><input type="text" name="user_id"  value="<?php echo $url_userid;  ?>" /></td>
  </tr>
  <tr>
    <td class="heading">Event Title</td>
    <td><input id="titleinput" name="title" type="text" value="<?php echo $selected_event ['title']; ?>" /><span class="compuls">*</span><span class="smalltext">Enter up to 36 characters</span></td>
  </tr>
  <tr>
  <td class="heading">Current Status</td>
  <td><?php echo   $statusdescrip ['status_description']; ?>
  <select name="status_id" >
    <?php
      $status_set = findstatus();
      $statuslist = mysql_fetch_assoc ($status_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $statuslist ['status_id']; ?>" ><?php echo $statuslist ['status_description']; ?></option>
   <?php
   } while ($statuslist = mysql_fetch_assoc ($status_set));
   ?></select>
    <span class="compuls">*</span></td>
  </tr>
      <tr>
    <td class="heading">Organiser</td>
    <td><?php echo  $orgdescrip ['org_name']; ?>
    <select name="org_id">
    <?php
      $organisers_set = findorganisers();
      $orglist = mysql_fetch_assoc ($organisers_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $orglist ['org_id']; ?>" ><?php echo $orglist ['org_name']; ?></option>
   <?php
   } while ($orglist = mysql_fetch_assoc ($organisers_set));
   ?></select></td>
  </tr>
    <tr>
    <td class="heading">Start Date</td>
    <td id="dateinput"><?php echo $selected_event ['stdate']; ?></td>
  </tr>
    <tr>
    <td class="heading">Type Of Event</td>
    <td><?php echo  $typedescrip ['type_description']; ?>
    <select name="type_id">
    <?php
      $type_set = findtype();
      $typelist = mysql_fetch_assoc ($type_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $typelist ['type_id']; ?>" ><?php echo $typelist ['type_description'], $typelist ['type_id']; ?></option>
   <?php
   } while ($typelist = mysql_fetch_assoc ($type_set));
   ?></select><span class="compuls">*</span></td>
  </tr>
  <tr>
    <td class="heading">Venue</td>
    <td><?php echo  $venuedescrip ['ven_name']; ?><select name="ven_id">
    <?php
      $venues_set = findvenues();
      $venuelist = mysql_fetch_assoc ($venues_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $venuelist ['ven_id']; ?>" ><?php echo $venuelist ['ven_name'], $venuelist ['ven_id']; ?></option>
   <?php
   } while ($venuelist = mysql_fetch_assoc ($venues_set));
   ?></select></td>
  </tr>

  <tr>
    <td class="heading">Discipline</td>
    <td><?php echo  $disdescrip ['dis_description']; ?><select name="dis_id">
    <?php
       $discipline_set = finddisciplines();
      $dislist = mysql_fetch_assoc ($discipline_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $dislist ['dis_id']; ?>" ><?php echo $dislist ['dis_description'], $dislist ['dis_id']; ?></option>
   <?php
   } while ($dislist = mysql_fetch_assoc ($discipline_set));
   ?></select><span class="compuls">*</span></td>
  </tr>
  <tr>
    <td class="heading">Level</td>
    <td><?php echo  $leveldescrip ['level_description']; ?> <select name="level_id">
    <?php
       $level_set = findlevels();
      $levellist = mysql_fetch_assoc ($level_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $levellist ['level_id']; ?>" ><?php echo $levellist ['level_description'], $levellist ['level_id']; ?></option>
   <?php
   } while ($levellist = mysql_fetch_assoc ($level_set));
   ?></select></td>
  </tr>
    <tr>
    <td class="heading">Is This A Championship</td>
    <td><?php echo  $champdescrip ['champ_description']; ?><select name="champ_id">
    <?php
      $championship_set = findchampionships();
      $champlist = mysql_fetch_assoc ($championship_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $champlist ['champ_id']; ?>" ><?php echo $champlist ['champ_description'], $champlist ['champ_id']; ?></option>
   <?php
   } while ($champlist = mysql_fetch_assoc ($championship_set));
   ?></select></td>
  </tr>
  <tr>
    <td class="heading">Event Details</td>
    <td><textarea name="event_details" cols="45" rows="15" ><?php echo $selected_event ['event_details']; ?>  </textarea></td>
  </tr>
  <tr>
    <td class="heading">Upload Schedule</td>
    <td></td>
  </tr>

  <tr>
  <td></td>
  <td><input type="submit" name="submit" id="convert" value="Update Your Event"></td>
  </tr>
</table>
<a  class="delete" href="controlpanel.php">Cancel</a>
</form>
    </div>
    <div id="adminright">
    </div>
<br clear="all" />
<?php require("includes/lowerlistings.inc.php"); ?>
<?php require("includes/footer.inc.php"); ?>
</div><!--End of Wrapper-->
</body>
</html>

Hi there. I have a page that lists the records of a table. On this page I want to be able to edit/update two attributes of these records by a checkbox - e.g., being able to update multiple records at once. I thought the smartest way to achieve this would be by using arrays. I've implemented one checkbox array and have two fields. Currently when I change both fields and hit submit, the height value changes and the name value is changed to the last record displayed in the table.

E.g.

Height - 170 -> 160 -> UPDATED TO 160
Name - Test1 -> Test2 -> UPDATED TO VICTORY (last record listed in table; displayed alphabetically)

My code is as follows:

<?php
include("connection.php");
$conn = oci_connect($UName,$PWord,$DB) or die("Database Error - Contact Admin - sjrei5@student.monash.edu");
if (empty($_POST["check"]))
{
    $query = "SELECT * FROM HORSE ORDER BY HORSE_NAME";
    $stmt = oci_parse($conn,$query);
    oci_execute($stmt);
$Horses = oci_fetch_array ($stmt);
?>
    <form method="post" action="horse_multi.php">
      <table border="1" id="customers">
      <tr>
        <th>ID</th>
        <th>EDIT</th>
        <th>NAME</th>
        <th>HEIGHT</th>
      </tr>
<?php
while ($Horses = oci_fetch_array ($stmt))
{
?>
        <tr>
          <td><?php echo $Horses["HORSE_ID"]; ?></td>
          <td align="center"><input type="checkbox" name="check[]" value="<?php echo $Horses["HORSE_ID"]; ?>"></td>
          <td align="center"><input type="text" size="5" name="<?php echo $Horses["HORSE_ID"]; ?>" value="<?php echo $Horses["HORSE_HEIGHT"]; ?>"></td>
          <td align="center"><input type="text" size="20" name="HORSE_NAME" value="<?php echo $Horses['HORSE_NAME']; ?>"></td>
        </tr>
<?php
}
?>
      </table><p />
        <h4><input type="submit" value="Update Selected Horses"></h4>
    </form>
<?php
oci_free_statement($stmt);
}
else
{

foreach($_POST["check"] as $horse_id)
{
$query = "UPDATE HORSE SET HORSE_NAME= '$_POST[HORSE_NAME]', HORSE_HEIGHT = ".$_POST[$horse_id]." WHERE HORSE_ID ='".$horse_id."'";
$stmt = oci_parse($conn,$query);
oci_execute($stmt);
}
}
?>
</body>
</html>


Any ideas? 

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

hello i had a look here its prety simple example http://www.formget.com/php-checkbox/     i wish something like this but with many more check boxes about 100,   the senario ls like this   there will be many users in a system,   each user profile will have these kind of questions   for example   Hobby : tenis [] badminton[] footbal[] carrom[]   programming language : perl[] python[] cobol[] as3[]   favorit biscuit : bakers[] subana[] ect[]     ect ect   these checkbox need to reflect for diferent users. administrator can add new category [ ie hobby , programming language] under each category he can add more options such as football, tenis ect   he should be able to have an interface to modify the options entered by user when a user request a change     what is a good way to implement this in php mysql      

Which languages do I need to make this happen? And I am unsure of how to incorporate PHP within a javascript query and what jQuery functions I will need.