Hi all, 

Right now I'm trying to retrieve one of the column "tutor_name" and display al 
the tutor's name in a drop down list. The problem now is, the drop down list 
only manage to display 1 record from that row instead of all tutor's name 
under "tutor_name" column...wonder where the problem lies??
Hope to get some help soon.
Below is a snip of the code: 
Drop me a msg if anyone needs the entire code.

<SELECT NAME="tutor_name" class="textarea">

$sql = mysql_query("SELECT DISTINCT tutor_name FROM tutor ");
if ($row = mysql_fetch_array($sql))
 print "<OPTION VALUE=\"$tutor_name\" SELECTED>" .$row
["tutor_name"]. "</option>";
 $result = $db->query($sql);


Thanks in advance =)


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to