is there something wrong with my code?

[Anon]

I am tring to display everything from the table and when I pull it up I only get one entry to show up. I know that there is more than one entry. I can do select from newone on the command line and it shows all. I dont know if this matters but it is running on win98 with apache, php and mysql. All the latest versions...If anyone can help....
<?
mysql_connect("localhost", "username", "password");
mysql_select_db("testdatabase");
$result = mysql_query("SELECT FROM newone");
if ($row = mysql_fetch_array($result)) {
{
echo $row["firstName"];
echo " ";
echo $row["lastName"];
echo " <br>";
}
while ($row = mysql_fetch_array($result));
}
else { echo "Sorry, No Records Found."; }

?>

[Anon]

I am very new to php and mysql but have you tried somthing like this?:

<?
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("testdatabase");
$result = mysql_query($db, "SELECT * FROM newone");
while ($row = mysql_fetch_array($result))
{
echo $row["firstName"];
echo " ";
echo $row["lastName"];
echo " <br>";
}
else
}
echo "Sorry, No Records Found.";
}

?>

[Anon]

Yes, the issue is that you were not looping through your returned rows, so it only displayed one row.