reversing row order

[nabeels786]

hey

    $sql = "SELECT * FROM announcement ORDER BY announcementid DESC LIMIT $num, 5";
        $result = mysql_query($sql);
        $sql = "SELECT * FROM " .  $result . " ORDER BY announcementid ORDER BY ASC)"; 

that doesnt work, i want to pick out the last 5 rows, and instead of them showing as 15-16-17-18-19-20, i want it go in reverse order, from 20 to 15.

if i do "ASC" instead of desc in the first sql statement, it picks 1->5 instead, i tried nested statements too, didnt work. ideas?

$sql="SELECT * FROM (SELECT * FROM announcement LIMIT $num, 5) ORDER BY announcementid ORDER BY ASC" 

$num = number of rows - 5

thanks

[JafferAB]

if you want it to display tyem you coudl try putting htem into an array backwards, then itll print them forwards

[GSHelpBoy]

$sql = "SELECT * FROM `announcements` ORDER BY `id` DESC LIMIT $num, 5"; 

[Xmevs]

how about making a virtual table with the ones selected...

[The Hobo]

Originally posted by nabeels786

$sql = "SELECT * FROM " .  $result . " ORDER BY announcementid ORDER BY ASC)"; 

You don't need that second ORDER BY:

$sql = "SELECT * FROM " .  $result . " ORDER BY announcementid ASC)"; 

[scoutt]

ASC doesn't have any impact on what rows you get. it just puts them in the order.

[The Hobo]

Well you can do the array thing that was suggested, or you can just get the number of records and subtract that by 5 to get your starting point.

[nabeels786]

i tried everything suggested, nothing worked.


hobo, thats what ive done, subtracted by 5, and use the limit to get the last 5, i want to reverse the last 5 it gives me

[The Hobo]

This works fine for me:

 $sql = "SELECT * FROM table ORDER BY id DESC LIMIT 5"; 

[scoutt]

why are you quering it twice? wouldn't this just work by itself

$sql = "SELECT * FROM announcement ORDER BY announcementid asc LIMIT $num, 5";
        $result = mysql_query($sql); 

[nabeels786]

it gives me 5->1

[nabeels786]

i dont know if it was the best way, but i stuck it into a for loop

    $num = mysql_num_rows(mysql_query("SELECT * FROM announcement"));
    for($i=1;$i<=5;$i++){
        $nnum=$num-$i;
        $sql = "SELECT * FROM announcement LIMIT $nnum, 1";
        $result = mysql_query($sql);
        while($row = mysql_fetch_array($result)){
            //its in order, output it how i want        
}
    } 

[scoutt]

Originally posted by nabeels786
it gives me 5->1

what id you echo $result?

if you use mysql_fetch_array() then it will do what you want.

[nabeels786]

yeah i always do mysql_fetch_array()

the loop worked, i dunno why the other ones didnt

[scoutt]

Originally posted by nabeels786
it gives me 5->1

so are you saying that when you echo the row out the id is 5 and goes down to 1? isn't that what you want.

[The Hobo]

my last post still works for me...

[scoutt]

I know that is the way I do it also. just can't see what he is doing that is doesn't work.

[The Hobo]

Originally posted by scoutt
Iknow tha tis the way I do it also. just can't see what he is doing that is doesn't work.

drinking again?

[nabeels786]

tried that, it gives me 15->20

[The Hobo]

Originally posted by nabeels786
tried that, it gives me 15->20

dude, I'm sorry, but you must be doing something retarded, because my solution works when I try it, and I'm pretty sure what scoutt is trying works for him. Why don't you post all of your code, plus a save of your database, so we can make it work for you?

[scoutt]

does it literrally print that out?

so on the screen you see 15->20 or does it print

ID
---
15....
16...
17.....
18.....
19.....
20.....

isn't that what you want? if not just use DESC instead of ASC.

Micheal you are confusing the bejesus out of me