reversing row order

hey

PHP Code:

---

    $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?

PHP Code:

---

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


---

$num = number of rows - 5

thanks

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

PHP Code:

---

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


---

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

Quote:

---

Originally posted by nabeels786

PHP Code:

---

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


---

---

You don't need that second ORDER BY:

PHP Code:

---

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


---

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

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.

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

This works fine for me:

PHP Code:

---

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


---

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

PHP Code:

---

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


---

it gives me 5->1

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

PHP Code:

---

    $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        
}
    } 


---

Quote:

---

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.

yeah i always do mysql_fetch_array()

the loop worked, i dunno why the other ones didnt :confused:

Quote:

---

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.

my last post still works for me...

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

Quote:

---

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? :p

tried that, it gives me 15->20

Quote:

---

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?

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 ;)