Select statement only returns 1 record
| From: | Todd Williamsen | Date: | Wed, 30 Jan 2002 18:45:25 +0000 |
| Subject: | Select statement only returns 1 record | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16325@lists.php.net to get a copy of this message | ||
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);
mysql_select_db($dbname,$db);
$sortby = "name ASC";
$sql="SELECT * FROM webl_players ORDER BY $sortby";
$result=mysql_query($sql,$db);
$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:
<?php
$db = mysql_connect($dbserver, $dbuser, $$dbpass);
mysql_select_db($dbname, $db);
$sql = "SELECT * FROM Canidate SORT BY 'LastName'";
$result = mysql_query($sql);
?>