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"; ?>

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 (http://www.php.net/)
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