Check the manual for the mysql_fetch_array() function, it shows you how to 
extract data from $result. You will use the while loop (as shown in the 
manual's example) to fill your combo box / selct list /drop down menu, 
whatever we're calling that creature today.


At 12:45 PM 1/30/2002 -0600, Todd Williamsen wrote:
>I am trying to get data from two columns, FirstName and Last name and
>displaying all the records LastName, FirstName in a drop down menu.
>The weird thing is that it only displays one record.  I thought the table
>was hosed, but its not.  I tried it through another database and still
>doesn't work.
>Here is the code:
>$db = mysql_connect($dbserver, $dbuser, $dbpass);
>$sortby = "name ASC";
>$sql="SELECT * FROM webl_players ORDER BY $sortby";
>$row = mysql_fetch_array($result);
>$FirstName = $row["FirstName"];
>$LastName = $row["LastName"];
><select name="canidate">
>           <option selected>
>           <?php echo "$LastName, $FirstName"; ?>
>           </option>
>I would list the whole page but its long!  There is another SQL statement at
>the top of the page:
>$db = mysql_connect($dbserver, $dbuser, $$dbpass);
>mysql_select_db($dbname, $db);
>$sql = "SELECT * FROM Canidate SORT BY 'LastName'";
>$result = mysql_query($sql);
>PHP Database Mailing List (
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to