[SOLVED] mysql_fetch_array with array_reverse

[Fsoft]

Hello,

$query2 = mysql_query("SELECT * FROM articles where art_cat = $cat");
		while($art_infos = mysql_fetch_array($query2))
		{

echo $art_infos["art_title"];

		}

 

Using this code above, I am able to echo out all the existing art titles available in my database, the only problem is, their order is from new older to new. I mean the title on top is older and the title on the last is the newer. I want them in reverse order,

 

so from NEW to OLD which makes a sense. I tried to use array_reverse. But it doesn't seem to work.

 

Please help me, how can I echo them out in reverse order?

 

Thanks a lot.

 

FAISAL!!!!!!!

 

[WolfRage]

http://us2.php.net/manual/en/function.array-reverse.php

[Fsoft]

http://us2.php.net/manual/en/function.array-reverse.php

 

Yes that I already saw, but in this code, where I can place the array_reverse to get it workign?

 

I tried but it is not working...!

 

[WolfRage]

<?php
$query2 = mysql_query("SELECT * FROM articles where art_cat = $cat");
while($art_infos = array_reverse(mysql_fetch_array($query2)))
{

echo $art_infos["art_title"];

}
?>

[mattal999]

Or:

 

<?php

$query2 = mysql_query("SELECT * FROM articles where art_cat = $cat ORDER BY art_title ASC");
while($art_infos = mysql_fetch_array($query2))
{
echo $art_infos["art_title"];
}

?>

 

EDIT: That should work.

[Fsoft]

Thanks friends, but sadly non of them worked ...

 

The 1st one "WolfRage" gives an error... And mattal999 was suppose to work but actually no it gives up same result as if I do it without changing my query

 

Any other help???

 

Thanks...

[.josh]

As mattal999 mentioned, you'll want to order it in your query. 

 

You are saying you want "newer" ones first.  Which column in your table signifies older vs. newer? Is there a date column? Id column? You will want to

 

... ORDER BY column DESC

 

 

 

[Fsoft]

WOW!!!!!!

 

Thanks Crayon Violent.. I will never forget this thing

 

Thanks a lot.If I get an other problem will post here, this forum always helps me ... like always..

 

FAISAL!