Fetching array then reversing it

Posted on 16th Feb 2014 07:03 pm by admin

Hi, I have a simple problem, I'll try to explain it as best I can:
News entries in my database are ordered from oldest to newest. In order to pull out the last 10 lines I do this:
$newsquery=mysql_query("SELECT * FROM news ORDER BY timestamp DESC LIMIT 10");
while($row = mysql_fetch_array($newsquery)){
echo '<b>' .$row['line']. '</b>
';
}
It spits out something like this:
most recent news in db
second most recent news in db
third most recent news in db
etc...

The problem is I need to flip that list so the oldest of the 10 is on top and the newest is on bottom.

What I've tried:
$row = array_reverse(mysql_fetch_array($newsquery)))
array_reverse didn't seem to do anything.

I've also read that it can be done with a subquery, but the explanation wasn't that great.
Any help would be much appreciated!

Other php-forum

Insert numbers from Barcode scanner into online php page
I have a real big problem, Here is what I'm trying to do. I have a Intermec CN3 handheld computer th

Typing math
I've added support for typesetting math using LaTeX on the forums.

Example:
Code: [Select]

Error In Syntax
I got this error:

Code: Parse error: syntax error, unexpected '>' in /home/bucket/publ

Login Script Issues
I am using a script I got from http://phpsense.com/php/php-login-script.html in order to allow peopl

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s

I need some help with the IF command...
I have a large number of images in one section of my website with the .jpg format. I'm adding a bun

paginate search result
Hi, I have a paginations script to display data from my database but i would like to paginate someon

Career Change into SAP
Hai
I am sajesh ,did my diploma in Mechatronics i have a 4 years of experience in

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

php wont update my db
hello,

sorry for posting in mysql forum but i dont know where exactly is the problem but here