looping through rows

[Anon]

how do i loop through rows. I am only getting a display of one entry when there is more. here is my code.
<?
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."; }

?>

[phpjeff]

Try placing the ECHO inside the WHILE LOOP:

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

?>

[[deleted]]

Close but no cigar...

<?&nbsp;
mysql_connect("localhost",&nbsp;"username",&nbsp;"password");&nbsp;
mysql_select_db("testdatabase");&nbsp;
if&nbsp;(!$result&nbsp;=&nbsp;mysql_query("SELECT&nbsp;*&nbsp;FROM&nbsp;newone"))
{
&nbsp;&nbsp;echo&nbsp;'SQL&nbsp;ERROR:'.mysql_error();
}
else
{
&nbsp;&nbsp;if&nbsp;(mysql_num_rows($result)==0)
&nbsp;&nbsp;{&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;'no&nbsp;results';
&nbsp;&nbsp;}
&nbsp;&nbsp;else
&nbsp;&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;while&nbsp;($row&nbsp;=&nbsp;mysql_fetch_array($result,&nbsp;MYSQL_ASSOC))
&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;$row["firstName"];&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;"&nbsp;";&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;$row["lastName"];&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;"&nbsp;<br>";&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;
&nbsp;&nbsp;}
}
?>

and read this just to clarify what's going on:
http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=12

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[Anon]

the usual problem, seems to me to be the greatest disadvantage of this database, or maybe of all databases - the results are always displayed only inside the loop, if outside, the $row variable means nothing.