[SOLVED] Ordering by ASC

[DJTim666]

I am having trouble ordering by ASC.

 

I made a tagbox, and when it loads up it takes you to the bottom of the page, and it should show the newest comment first, but it doesn't. It shows the first 25 tags then stops...

 

mysql_query("SELECT * FROM {table} ORDER BY id ASC LIMIT 25");

 

Any suggestions?

 

--

DJ

[HuggieBear]

Newest comment first is DESC (Descending) not ASC (Ascending).

 

Rergards

Huggie

[DJTim666]

If I order by DESC then will show the newest tag at the top...

 

Is there any way to reverse DESC?

[HuggieBear]

If you're ordering by ID (Assuming that id is auto incrementing) then use DESC

 

Regards

Huggie

[DJTim666]

I can't order by DESC because it will show the newest tag at the top of the page. I want the newest post to be shown at the bottom (like most tagboxes do).

 

Can I use DESC and still be able to show the newest tag at the bottom of the screen?

 

so an example would be;

 

old

old

old

old

new

[HuggieBear]

What columns are in your database?

 

Huggie

[DJTim666]

id, message, username, ip

[HuggieBear]

OK, well the tagbox here shows the newest messages at the top of the box!

 

Which would be "SELECT * FROM table ORDER BY id DESC LIMIT 25".

 

If you wanted it the other way around then you'd need to use this more than one query.

 

Regards

Huggie

[DJTim666]

The tagbox here takes you to the bottom of the screen and shows the newest tag at the bottom.

 

nvm, you cant see it unless you are logged in anyways.

 

i'll figure it out someday =).

[HuggieBear]

I can't see that, I guess it's a member only feature.

 

You can do it, but you'd need more than one query, that's all.

 

Regards

Huggie

[HuggieBear]

Something like this should work (Untested)...

 

<?php
// Maximum posts to show
$show = 25;

// Run the query and assign the total rows to a variable
$r = mysql_query("SELECT count(`id`) FROM `table`");
$total = mysql_result($r, 0, 0);

// Set the true offset if the value is less than 0
$offset = ($total - $show < 0) ? 0 : $total - $show;

// Run the query with the offset
$r = mysql_query("SELECT * FROM `table` ORDER BY id LIMIT $offset, $show");

// Then process $r as you were before
?>

 

Regards

Huggie

[DJTim666]

That works perfect Huggie. Thank you very much for that.