On Mon, 20 Aug 2001 02:12, Chris Lambert wrote:
> It'd help if you have us the mysql_error() returned.
>
> Try the following:
>
> SELECT *, substring_date AS SUBSTRING(date,5,2) FROM $table ORDER BY
> substring_date
>
Date is a reserved word in Mysql. Also, that might work better, after
renaming the field from date, as
SELECT *, SUBSTRING(datefield,5,2) AS substring_date FROM $table ORDER BY
substring_date
>
> ----- Original Message -----
> From: Seb Frost <[EMAIL PROTECTED]>
> To: Tom Carter <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Sunday, August 19, 2001 11:19 AM
> Subject: RE: [PHP] MySQL substrings?
>
> | This doesn't work:
> |
> | $result = mysql_query("SELECT * FROM $table ORDER BY
> | SUBSTRING(date,5,2)")
> |
> | Any idea why?
> |
> | - seb
> |
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
Oxymoron: Soviet Life.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
