here is how i would do it, a slight change to the if else ..
function filelist($fileID) { $result=mysql_query("SELECT ID,title,type FROM files"); echo "<BR>"; echo "<select name=\"file\"><option value=\"0\">---NONE---</option>"; if (mysql_num_rows($result)==0) { //no files } else { while ($row=mysql_fetch_array($result)) { $ID=$row["ID"]; $title=$row["title"]; $type=$row["type"]; echo "<option ".$ID==$fileID ? "selected" : ""." value=\"$ID\">" . $type . " - " . $title . "</option>"; } } echo "</select><BR>"; } -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]