Re: newbie question: results by page
From: John (gt2243a_at_mail.gatech.edu)
Date: 03/10/04
- Next message: dr zoidberg: "Unix timestamp update"
- Previous message: Ruby Tuesday: "Re: Find a file using php"
- In reply to: Tony Marston: "Re: newbie question: results by page"
- Next in thread: Shawn Wilson: "Re: newbie question: results by page"
- Reply: Shawn Wilson: "Re: newbie question: results by page"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 10 Mar 2004 13:17:44 -0500
"Tony Marston" <tony@NOSPAM.demon.co.uk> wrote in message
news:c2k3qk$mrl$1$8300dec7@news.demon.co.uk...
> If you want the data to be presented in a particular order then use the
> ORDER BY [column name] DESC clause of your sql SELECT statement.
>
> See
>
http://www.mysql.com/documentation/mysql/bychapter/manual_SQL_Syntax.html#SELECT
> for details.
>
I tried this but this is what I get: Invalid query: You have an error in
your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to use near 'ORDER BY id DESC' at line 1
What I used is "ORDER BY id DESC" since I'm trying to display my records
from last entered to first.
- Next message: dr zoidberg: "Unix timestamp update"
- Previous message: Ruby Tuesday: "Re: Find a file using php"
- In reply to: Tony Marston: "Re: newbie question: results by page"
- Next in thread: Shawn Wilson: "Re: newbie question: results by page"
- Reply: Shawn Wilson: "Re: newbie question: results by page"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
