Problem with while statement

[Freebieholics]

Hi people, im new to this forum, and almost as new to PHP.

I'm using the following code. It connects to the db ok and pulls the correct amount of records. But the while loop is somehow causing the first record pulled to not be displayed.

mysql_select_db($dbname,$db);
$infquery="select * ......";
$infresult = mysql_query("$infquery");
$infrows = mysql_fetch_array($infresult);

while ($infrows = mysql_fetch_array($infresult)) {

code to run

}

Could someone help me please.

Freebie

[nemonoman]

$infrows = mysql_fetch_array($infresult);

//selects the first row

//but you don't do anything with this row, you just go to:

while ($infrows = mysql_fetch_array($infresult)) {

//which etches row 2 ...n. These you do manage, apparently

comment out the first $infrows... statement, and all will be well

[Freebieholics]

Thank you very much for that.

A lesson learned.

I like this place, you'll all be seeing more of me 🆒

Freebie