Forum Moderators: coopster

Message Too Old, No Replies

ordering the database

i need to reverse the order in the homepage

         

Toldo

2:50 pm on Aug 26, 2005 (gmt 0)

10+ Year Member



hi,
i have a download center in my website ..
the code that calls the files with ID order is

<?
@$aepublic->DBQuery("SELECT * FROM multimedia where homepage =1 ORDER BY ID");
while ($aepublic->DBGetRow())
{
//$filename=$aepublic->access["file"];

?>

it now start from the lower ID to the higher one ..
example:
if a file has an ID "10" & another has an ID "11"
he will get the file with the "10" first .. i need to get the file with the "11" so that the most recent one is in the top ..

anybody help ...

DanA

3:07 pm on Aug 26, 2005 (gmt 0)

10+ Year Member



You can use desc (or asc) in your query
[webmasterworld.com...]