RE: [PHP-DB] Select statement only returns 1 record

[Rick Emery]

It's worked for me.  

You'll note that I added a new column "id".  Did you put that in your
table??
What error did you get????????

-----Original Message-----
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 2:18 PM
To: 'Rick Emery'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Select statement only returns 1 record


Nope, that doesn't work

-----Original Message-----
From: Rick Emery [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 30, 2002 1:01 PM
To: 'Todd Williamsen'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Select statement only returns 1 record


<?
$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);

print "<select name="canidate">";
while( $row = mysql_fetch_array($result) )
{
$FirstName = $row['FirstName'];
$LastName = $row['LastName'];
$id=$row['id'];
print "<option value=$id >$LastName, $FirstName</option>";
}
?>
print "</SELECT>";

-----Original Message-----
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 12:45 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Select statement only returns 1 record


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



-- 
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]

-- 
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]