[Jambone]

Hi all,

I am trying to get this so it echoes out rows, according to an option selected in a drop down box

The drop down box is coded like so:

PHP Code:

<select id="depicao" name="depicao"><option value="">Please select a departure airfield</option>'; $selectflights = mysql_query("SELECT * FROM `airports`"); while($fselect = mysql_fetch_array($selectflights)) { echo '<option value="'. $fselect['icao'] .'">'. $fselect['name'] .'</option>'; } echo '</select> 

The table like so:

HTML Code:

<table width="700px" style="margin: 0 auto;border: 2px solid #696969;text-align: center;" id="flightlist">
<tr style="border-bottom: 1px dashed #000;">
<td style="padding: 5px;font-weight:900;">Flight ID<br />(click for full flight information)</td>
<td style="padding: 5px;font-weight:900;">Departure Airport</td>
<td style="padding: 5px;font-weight:900;">Arrival Airport</td>
<td style="padding: 5px;font-weight:900;">Equipment</td>
<td style="padding: 5px;font-weight:900;">Book this flight?</td>
</tr>'
</table>

The javascript page like so:

Code:

function getFlights() {
    if($('#depicao').val() == ''){
     $('#flightlist').html('<tr bgcolor="white"><td style="padding: 5px;" class="grey">There are no flights departing from the selected airport</td></tr>');
     } else {
        $.ajax({
            type: 'GET',
            url: '../ajax_funct/ajax.flightlist.php',
            data: 'depAirfield='+$('#depicao').val(),
            success: function(data){
                if($.trim(data) != 'false'){
                    $('#flightlist').html(data);
                } else  {
                    $('#flightlist').html('<tr bgcolor="white"><td style="padding: 5px;" class="grey">There are no flights departing from the selected airport</td></tr>');
                    }
                }
        });
    }
}

and the AJAX php update page like so:

PHP Code:

 <?

 require('../mysql_connect.php');

 $depicao = $_GET['depAirfield'];

 $listflights = mysql_query("SELECT * FROM `flights` WHERE dep_icao = '$depicao'");

 if(mysql_num_rows($listflights) >= 1) {

 while($alflights = mysql_fetch_array($listflights)) {

$color1 = '#f9f7bb';

$color2 = '#bfd0f8';

 $row_color = ($row_count % 2) ? $color1 : $color2; 

echo '<tr bgcolor="'. $row_color .'" >

<td style="padding: 5px;" class="grey"><span class="rost"><a href="index.php?page=flightinfo&id='. $alflights['id'] .'">'. $alflights['id'] .'</a></span></td>

<td style="padding: 5px;" class="grey">'. $alflights['dep_icao'] .'</a></td>

<td style="padding: 5px;" class="grey">'. $alflights['arr_icao'] .'</a></td>

<td style="padding: 5px;" class="grey">'. $alflights['equipment'] .'</a></td>

<td style="padding: 5px;" class="grey"><form method="post" action="booked.php?id='. $alflights['id'] .'&pid='. $id .'"><input type="submit" value="" name="submit" style="border:none;background: url(\'images/book.png\');width:51px;height:16px;">

</form></td>

</tr>';

$row_count++;

}

} else {

echo 'false';

}

?>

Thanks all

[Jambone]

Ok, I have managed to get it to work, forgot to set the onChange="" attribute, however now it shows the data, but not in a new row, instead it removes the other row, I think I can fix that by just entering the whole code to be echoed. Will let you guys know

[Jambone]

Alright, I managed to get it working Thanks anyway guys.