Topic awaiting preservation: mysql showing more than one result. (Page 1 of 1)

ok, so I'm writing a little guestbook script for my new site, and everything was going fine, until I was trying to view the entries. I want to view many entries at a time in descending order of timestamp the code is this:

$db = mysql_connect("kewlster.com","username","password");
mysql_select_db("guestbook",$db);
$query = "SELECT * FROM entries ORDER BY timestamp DESC";
$result = mysql_query($query,$db);
if($results = mysql_fetch_array($result)){
echo "<BR><BR><BR>\n";
foreach($results as $key => $value){
echo "$key - $value<BR>\n";
}


as you see it gets the results, puts them in an array and then prints them all out to the screen, but the problem is that it's only printing the first result. Please help ASAP.

http://www.kewlster.com

everytime you do fetch_array you get the next line into the array. so if you do it only once, you only get the first line.

try using
while(mysql_fetch_array(...)) {
...
}

instead of the if().

as Grumble said, I add:

while($row = mysql_fetch_array($result))

{

  echo "<BR><BR><BR>\n";

  foreach($row as $key => $value){

  echo "$key - $value<BR>\n";

}

basically, mysql_fetch_array() returns a row and not the set of all results.