MySQL & php Dynamic display and filtering

[Anonymous]

does your onchange event work ?
please echo all the SQL statements, so that you can check

 

[Anonymous]

Hello,

<?php  
echo '<form name="orderform" method="post" action="'.$_SERVER['PHP_SELF'].'">';
// Check to see if category has been sent 
$event_name = isset($_GET['event_name'])?    $_GET['event_name']: 0;  

echo '<p> 
    <select name="event_name" id="event_name" onchange=\'this.form.submit();\'> 
        <option value="0"'.($event_name == 0? ' SELECTED': '').'>Choose an Event</option>';  
?>

<?php
echo '<p> 
    <select name="event_name" id="event_name" onchange="this.form.submit();"> 
        <option value="0"'.($event_name == 0? ' SELECTED': '').'>Choose an Event</option>';  
?>

You don't need to escape the " if they are within a single quote '

 

[gesf]

Your HTML form has a POST method and you're using $_GET[] in your PHP.
Use $_POST[] instead.