[SOLVED] Fetch Array problem

[Aso]

Hello!

I'm trying to show snippets of the most recent 3 posts in a database, which I'm having slight success with.

But my query displays the second most recent post followed by the third - the most recent is nowhere in sight! And even though my LIMIT is 3, it only ever shows 2 posts.

PHP: Select all

$data = mysql_query("SELECT ID, 
                     post_date_gmt, 
                     post_content, 
                     post_title 
                     FROM wp_posts 
                     ORDER BY post_date_gmt DESC LIMIT 4")
                     or die(mysql_error());
                     
$info = mysql_fetch_array( $data );

while($info = mysql_fetch_array( $data )) {
print '<p><b>';
$ptitle = $info['post_title'];
$post_date = $info['post_date_gmt'];
list($date, $time) = explode(" ", $post_date);
list($year, $month, $day) = explode("-", $date);
$new_date = $day.'/'.$month.'/'.$year;
print $new_date. '</b>';
Print ' <a href="/news/?p='.$info['ID'].'" title="'.$ptitle.'">'.$ptitle.'</a><br />';
$post = substr($info['post_content'], 0 ,20);
Print $post."...</p>";
} 

Any ideas?

Thanks

Alex

[Rakuli]

Your problem is here

Code: Select all

$info = mysql_fetch_array( $data );

while($info = mysql_fetch_array( $data )) {

You only need to run

$info = mysql_fetch_array( $data );

inside the call to the while loop. Because the call to the mysql function changes the array pointer, it skips past the first record when you run it twice.

just use

while($info = mysql_fetch_array( $data )) {

[Aso]

Many thanks Rakuli

[Rakuli]

No problems