Problem with while

[zek2005]

I am doing the following statement to retrieve results:

$response = mysql_query("select * from preguntas where tema=$tema",
$db);
$row = mysql_fetch_array($response);
while($row = mysql_fetch_array($response))
{
echo('<font face="Tahoma" size="2">');
echo('<p align="left">');
echo($f .'- <a href="respuestas.php?id='. $row[id]. '">'
..$row[pregunta]. '</a>');
$f++;
}

I receive 2 items as a result. But if I check inside the DB, the result
should be 3 items....I am loosing the first record.

Any ideas about what could be wrong?

Regards,

Ezequiel

[Jerry Stuckle]

zek2005 wrote:

I am doing the following statement to retrieve results:

$response = mysql_query("select * from preguntas where tema=$tema",
$db);
$row = mysql_fetch_array($response);

This fetches the first row

while($row = mysql_fetch_array($response))

This fetches the second (and subsequent) rows, throwing away the results
of the first (and previous) rows.

{
echo('<font face="Tahoma" size="2">');
echo('<p align="left">');
echo($f .'- <a href="respuestas.php?id='. $row[id]. '">'
.$row[pregunta]. '</a>');
$f++;
}

I receive 2 items as a result. But if I check inside the DB, the result
should be 3 items....I am loosing the first record.

Any ideas about what could be wrong?

Regards,

Ezequiel

Get rid of the first

$row = mysql_fetch_array($response);
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================