$row = mysql_fetch_array($result)) problem

[alanita]

Hello,
Do you know why this code ( in particular line: if ($row = mysql_fetch_array($result)) ) takes put a first row from the result?

$result = mysql_query($sql);

if ($row = mysql_fetch_array($result)) {

$cols = $_POST['column_name'];
for ($i=0; $i<sizeof($cols); $i++) {
$fh_name = $cols[$i];
$fheader_name = 'outputheader' . $fh_name;
$fheader_name ($row['record_id']);
}
while ($row = mysql_fetch_array($result)) {
for ($i=0; $i<sizeof($cols); $i++) {
$fl_name = $cols[$i];
$fn_name = 'output' . $fl_name;
$fn_name ($row['record_id']);
}
}

I echoed mysql_num_rows($result) before executing the code (4 rows), but output of last while loop gives only 3 sets of rows.

When I removed first line if ($row = mysql_fetch_array($result)), then output gives correct number of rows 4. However, in that case, $row['record_id'] is underfined inside first "for" loop.

Do you know how fix that and why line ($row = mysql_fetch_array($result)) takes out a first row of a result set?

Thank you,

[tekky]

if ($row = mysql_fetch_array($result)) {

that makes the first result unavailable when you go into your while loop....

to fix it... add an $check = 0; before the while loop

then do

if ($check == 0) { set these variables; $check = 1; }

then it will set those variables for you on the first loop, and no other....

[alanita]

Hello Karl,
Thank you for the solution.

I'm really sorry, but I don't quite understand what do you mean by "set these variables" in line: if ($check == 0) { set these variables; $check = 1; }

I tried several combinations of your solution, it works somehow, but it now takes two more rows from the resulting set.

As you suggested, I put $check = 0; right before the while loop.
Then, after which line should I put if ($check == 0) {}?

Please help,
Thank you,

[mrhappiness]

just do it without the if

[tekky]

forget what i said earlier,

jsut replace if ($row = mysql_fetch_array($result)) {
with

if (mysql_num_rows($result) > 0) {

[alanita]

Thank you Karl,
It works now!