Reverse order for output

bthorud

hi!

I'm trying to make a very simple chat-client on a website. I want to output the last 20 postings (which is pretty easy to do), but I want to output them in reverse order, so that the posting with the latest date/time apears at the bottom. In MSSQL you can use the query listed below, but I only get an error in mysql.

$query = "SELECT chatLine, posted, postedBy FROM chat AND posted in (SELECT posted FROM chat ORDER by posted DESC LIMIT 20) ORDER by posted LIMIT 20";

Any ideas?

[deleted]

SELECT * FROM table ORDER BY date DESC LIMIT 20;

then read all the results into an array and print the array in reverse.

bthorud

Man, do I feel stupid right now 🙂

[deleted]

Life isn't that complicated all the time ;-)

Anon

You wrote: "...in (SELECT posted FROM chat ORDER by posted DESC LIMIT 20) ORDER..."

Just as a note to your original post, MySQL does not support sub-selects at this time.

Anon

Here's a stupid php-newbie question that's related: how can you print the the results in reverse?

Here's what I got -

<?
mysql_connect("localhost", "id", "pwd");
$result = mysql(dbname, "select * from News Order By ID");
$num = mysql_numrows($result);
$i = 0;

         while($i < $num) {
            echo "<h3>";
			echo mysql_result($result,$i,"Title");
            echo "<BR>";
            echo mysql_result($result,$i,"Author");
            echo "<BR>";
			echo mysql_result($result,$i,"Date");
            echo "</h3>";
            echo mysql_result($result,$i,"Message");
              $i++;}
      ?>

...Which of course outputs the rows in the SQL table ordered by the auto-incremented ID field. instead of having it print the rows in forward order (say, 1 through 6) how can I get them to print backwords - w/ row 6 at the top, down to 1 on the pages bottom?

thanks well in advance.

zkent

Joe, try this...

Change this line to
$result = mysql(dbname, "select * from News Order By ID DESC");

Ouput columns are sorted in ascending order by default. To specify a sort order for a column explicityl, follow the column indicator by ASC (asceding) or DESC (descending).

As a side note, MySQL 3.23.2, also allows you to use ORDER BY RAND() for a random order.

Zach

[deleted]

Note:
the original post was about ordering results by field A in descending order, then grabbing the last 20, and listing them in ascending order.

So Joe's question does not really relate to the original post.

Just so y'all don't get confused.

Anon

Joe Smacks own head

Oh yeah. I should have remembered that having already done plenty of SQL work... thanks!