[Resolved] Skipping MySQL data (first row) in array

[thanatos_nl]

Hello,

I have a problem with processing MySQL data through an array. When i use This code:

$q_machine = "select * from machine where customer = '" . $customer . "'";
$r_machine = @mysql_query($q_machine);
$f_machine = @mysql_fetch_array($r_machine);

while ($f_machine=@mysql_fetch_array($r_machine)) {
   print ("<a href='edit_machine.php?machine=".$f_machine[ID]."'> ".$f_machine[type]." &nbsp;|&nbsp;serial:".$f_machine[serial]."</a><br>");
}

The array keeps giving me 3 rows back, although there are 4 lines affected in the table (mysql_num_rows() also values 4). This happens throughout the entire site, when this code has never had this problem before. If i echo the machine ID before the while loop it gives the ID that gets lost in the array, how is this possible and how can i solve this ?

Thanx

Lennert

[liquorvicar]

here's your problem:

$f_machine = @mysql_fetch_array($r_machine);

while ($f_machine=@mysql_fetch_array($r_machine)) { 

the first mysql_fetch_array pulls a row from the database but you never do anything with it before the next mysql_fetch_array pulls the next row.

i'd suggest just getting rid of your first mysql_fetch_array line.

[thanatos_nl]

argh, off course (a friendly reminder not to write code after pulling an all nighter for an exam 😉 ), thanks !!!