ok, so i got a drop down list which is dynamically populated.
when i choose something form the list, it changes the content etc...
that all works fine.
but when populating the list( and i got different ones, which are linked to other tables in the db), the item which has been added last doesn't appear in the list.
so i got all my different items pulled from the db except for one.
this is the case with all my lists.
anyone got an idea what the problem could be ?
here's the code.
<form>
<form name="features" action="index2.php?" method="GET">
<input type="hidden" name="page" value="<?php echo $page ?>">
<input type="hidden" name="type" value="interview">
<select name="id" size="1" id="select" onchange="this.form.submit();">
<option selected="selected" class="choose"><i>Select an interview</i></option>
<?php
$query = "SELECT * from mash_features WHERE online='yes' AND type='interview' ORDER BY input_date DESC ";
$result = mysql_query($query) or die (mysql_error());
$row = mysql_fetch_array($result);
while ($row=mysql_fetch_array($result))
{
echo "<option class='value' value='".$row[ID]."'><b>".$row[interviewee]."</b></option>";
}
?>
</select>
</form>
when i delete this "AND type='interview'" i get all the items...
