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