While loop with mysql_fetch_array() in PHP

Question

Recently in one of my project i wrote the following code for retrieving and print data from database.

$query = "select * from tblteachers limit 0, 4";
$result= mysql_query($query) or die(mysql_error());

if(mysql_num_rows($result)>0)
{   
    while($fetchRow=mysql_fetch_array($result, MYSQL_BOTH))
    {
      echo $fetchRow['id'];
    }
}

in the tblteachers table there are 14 row and the query get 4 row but the problem is it print 3 row by missing the first row. that is it print 2, 3, 4.

Can you paste in the output of the query when you run it from the mysql monitor? An auto_increment field does have to be non-null/primary key to work in MySQL, but if you applied the auto_increment later via alter table, after data had already been inserted, there could very well be a record with a null id. — Marc B
– Marc B, Commented Dec 17, 2010 at 19:07
MYSQL_BOTH is useless, it is the second parameter's default value AND it clearly overheads the memory while it loads twice the same data. — Mathias E.
– Mathias E., Commented Dec 17, 2010 at 19:09
How about modifying your inner loop to output more than just the row's id value? try something like echo 'howdy' . $fetchRow['id']. If you get four howdy's, you know the loop executed four times. As well, if you're viewing this in a browser, never forget to do a 'view source', as html/browsers will hide many things and make them appear invisible. — Marc B
– Marc B, Commented Dec 17, 2010 at 19:17

Roy Toledo · Accepted Answer · 2011-04-15 23:35:15Z

1

you might have used something that moved the pointer. try adding mysql_data_seek($result,0); before the while statement

answered Apr 15, 2011 at 23:35

Roy Toledo

6435 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

While loop with mysql_fetch_array() in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related