Multipule drop down menus on an update page - How to omit unselected fields

[barniegilly]

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.

 

	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.

 

	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>