PHP while loop not showing first item?

Question

I'm just trying to show a basic list or items from my database but for some reason its not showing the first item so if there is only one thing in a category it doesn't show anything but if there's 2 it will show one item. I've added the code below.

query

 //this query will fetch 4 records only!
 $latestVideos = mysql_query("SELECT * FROM table ORDER BY date DESC LIMIT 5")or die(mysql_error());

 $posts = mysql_fetch_array($latestVideos);

While loop

 while($posts = mysql_fetch_array($latestVideos)){

 $dateFormat= $posts['video_date'];
 $newDate=date('d-m-Y',strtotime($dateFormat));

 echo $posts['video_title']
 echo $newDate;
 echo $posts['video_embed'];
 }

Anurag Ramdasan · Accepted Answer · 2013-03-09 20:15:49Z

8

mysql_fetch_array is used to return a row of the array at each iteration of the while loop.

The extra mysql_fetch_array takes the first row into post, and in the first iteration of the while loop it puts the second row into the post.

This is what you should be doing.

$latestVideos = mysql_query("SELECT * FROM table ORDER BY date DESC LIMIT 5")or die(mysql_error());

 while($posts = mysql_fetch_array($latestVideos)){
 //do stuff here
 }

answered Mar 9, 2013 at 20:15

Anurag Ramdasan

4,3305 gold badges34 silver badges53 bronze badges

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

2 Comments

huddds Over a year ago

so could i just do $posts = $latestVideos ?

huddds Over a year ago

Thanks a lot, that's been bugging me for a while

Sy Holloway · Accepted Answer · 2013-03-09 20:18:29Z

3

It looks like the first time you call "$posts = mysql_fetch_array($latestVideos);" the first row is retrieved and removed from $latestVideos. and the while loop then loops through the other rows.

answered Mar 9, 2013 at 20:18

Sy Holloway

4294 silver badges5 bronze badges

Comments

Andy Lester · Accepted Answer · 2013-03-09 20:18:11Z

2

You are fetching once with the mysql_fetch_array, but then not using the results. You're reading the first row and then throwing it away.

$posts = mysql_fetch_array(...); # Reads 1st row
while ( $post = mysql_fetch_array() ) { # reads 2nd-Nth row
}

answered Mar 9, 2013 at 20:18

Andy Lester

94.2k16 gold badges106 silver badges162 bronze badges

Collectives™ on Stack Overflow

PHP while loop not showing first item?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related