OPTION GONE CRAZY

[ecabrera]

ok this works fine and everything but when here when i try to let the admin changes stuff and goes to change the venue a list show appear and it does but when it save it save it as

 

RBB FIELD <option value="RED BULL ARENA">RED BULL ARENA</option><option value="RBB FIELD ">RBB FIELD </option><option value="RED BULL ARENA">RED BULL ARENA</option>

 

why does it do that?? HElp ANYONE

 

Code

<?php 

if (isset($_GET['eid'])){

$newid = $_GET['eid'];

$sqlCommand = "SELECT * FROM events WHERE id='$newid' LIMIT 1"; 
$out = mysql_query($sqlCommand);
$row = mysql_fetch_assoc($out);

  $eventid = $row["id"];
  $eventname = $row["eventname"];
  $eventtype = $row["typeevent"];
  $eventinfo = $row["eventinfo"];
  $date = $row["date"];
  $time = $row["time"];
  $livetickets = $row["sale"];
  $numtickets = $row["numtickets"];
  $pricestudents = $row["studentsprice"];
  $priceseniors = $row["seniorsprice"];
  $priceadults = $row["adultsprice"];
  $venues = $row["venue"];
  $category = $row["category"];
  
$query = mysql_query("SELECT venuename FROM venue");
while ($row = mysql_fetch_array($query)){

$venues .= '<option value="' . $row['venuename'] . '">' . $row['venuename'] . '</option>';
}

$form = "<form action='eevent.php' method='post' enctype='multipart/form-data'>
<table>

<tr>
<td>REQUIRED FIELDS *</td>
<td></td>
</tr>

<tr>
<td>Event Name*</td>
<td><textarea cols='17' rows='1' name='eventname' />$eventname</textarea></td>
</tr>

<tr>
<td>Type of event*</td>
<td><textarea cols='17' rows='1' name='typeevent' />$eventtype</textarea></td>
</tr>

<tr>
<td>Event Inforamtion*</td>
<td><textarea name='eventinfo' cols='40' rows='5'>$eventinfo</textarea></td>
</tr>

<tr>
<td>Date</td>
<td><input type='text' size='10' name='date' value='$date' /></td>
</tr>

<tr>
<td>Time</td>
<td><input type='text' size='10' name='time' value='$time' /></td>
</tr>

<tr>
<td>When tickets go on sale</td>
<td><input type='text' size='10' name='sale' value='$livetickets' /></td>
</tr>

<tr>
<td>Number of Tickets Available </td>
<td><input type='text' size='5' name='numtickets' value='$numtickets' /></td>
</tr>

<tr>
<td><h4>Ticket Prices</h4></td>
</tr>
<tr>
<td>STUDENTS</td>
<td>$<input type='text' size='3' name='studentsprice' value='$pricestudents'/></td>
</tr>
<tr>
<td>SENIORS</td>
<td>$<input type='text'  size='3' name='seniorsprice' value='$priceseniors'/></td>
</tr>
<tr>
<td>ADULTS</td>
<td>$<input type='text' size='3' name='adultsprice' value='$priceadults' /></td>
</tr>
<tr>
<td>SELECT VENUE</td>
<td>
<select name='venue'>
<option value='$venues'>$venues</option>
</select>
</td>
</tr>
<tr>
<td>SELECT CATEGORY</td>
<td>
<select name='category'>
<option value='$category'>$category</option>
<option>FOOTBALL</option>
<option>BASKETBALL</option>
<option>HOCKEY</option>
<option>DRAMA</option>
<option>MUSIC</option>
<option>DANCE</option>
<option>VISUAL ARTS</option>
</select>
</td>
</tr>


<tr>
<td></td>
<td><input type='hidden' name='saveevent' value='$newid'/></td>
<td><input type='submit' name='savechanges' value='Save Changes'/></td>
</tr>
</table>
</form>";
   
echo "$form";  

} 
   
if ($_POST['saveevent']){

  $newid = mysql_real_escape_string($_POST['saveevent']);
  $eventname = mysql_real_escape_string($_POST['eventname']);
  $eventtype = mysql_real_escape_string($_POST['typeevent']);
  $eventinfo = mysql_real_escape_string($_POST['eventinfo']);
  $date = mysql_real_escape_string($_POST['date']);
  $time = mysql_real_escape_string($_POST['time']);
  $livetickets = mysql_real_escape_string($_POST['sale']);
  $numtickets = mysql_real_escape_string($_POST['numtickets']);
  $pricestudents = mysql_real_escape_string($_POST['studentsprice']);
  $priceseniors = mysql_real_escape_string($_POST['seniorsprice']);
  $priceadults = mysql_real_escape_string($_POST['adultsprice']);
  $venues = mysql_real_escape_string($_POST['venue']);
  $categorys = mysql_real_escape_string($_POST['category']);
  
  
$sqlCommand = "UPDATE events SET eventname='$eventname', typeevent='$eventtype', eventinfo='$eventinfo',
date='$date', time='$time', sale='$livetickets', numtickets='$numtickets', studentsprice='$pricestudents',
seniorsprice='$priceseniors', adultsprice='$priceadults', venue='$venues', category='$categorys' WHERE id='$newid'"; 
$out = mysql_query($sqlCommand);

echo "SAVE CHANGES COMPLETED!";

}

    
?>

[Pikachu2000]

You're echoing a list of <option></option> tags within another set of <option></option> tags here:

<option value='$venues'>$venues</option>

[ecabrera]

thanks