Same Three Results

[Anon]

Hi,

I'm trying to use the following code to display the first three results from a mySQL query :

$i = 1;
if ($myrow = mysql_fetch_array($books)) {
do {
printf("<IMG SRC=\"../images/new02.gif\"><A HREF=\" %s \">%s</A> - \"%s\"<br>\n", $myrow["URL"], $myrow["Title"], $myrow["Description"]);
$i++;
} while ($i <= 3);
} else {
echo "Sorry, no books were found!";
};

What I have give me the same results over and over...the first record in the table. I'm missing something pretty obvious here, but am not sure what it is. Any help is appreciated! Thanks!

[brandonschnell]

if (mysql_num_rows($books) == 0)
echo "Sorry, no books were found!";

$i = 1;

while ($myrow = mysql_fetch_array($books) && $i <= 3)
{
printf("<IMG SRC=\"../images/new02.gif\"><A HREF=\" %s \">%s</A> - \"%s\"<br>\n", $myrow["URL"], $myrow["Title"], $myrow["Description"]);
$i++;
}

[Anon]

Brandon,

Thanks for the help. It does only give me three records...however, I don't get any of the data from those records. Just the formated link (didn't insert the URL, Title, or Description). I'm still working on it, but am not sure what the problem is.

Thanks,

Mark

[Anon]

Brandon,

Thanks for the help. It does only give me three records...however, I don't get any of the data from those records. Just the formated link (didn't insert the URL, Title, or Description). I'm still working on it, but am not sure what the problem is.

Thanks,

Mark

[mp96brbj]

I've noticed mysql_fetch_array behaves strangely if you ask for several things in the while statement. I don't know exactly why, but I have a workaround: Try putting $myrow = mysql_fetch_array($books) inside the loop like this:

if ($myrow = mysql_fetch_array($books))
{
$i = 0;
do {

(Print your stuff from $myrow here.)

$myrow = mysql_fetch_array($books);
$i++;

} while ($myrow && $i < 3);
}
else
{

D'oh, nothing found!

}

[Anon]

Björn,

Thanks for the help...it works!

Mark