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
/* Chris Lambert, CTO - [EMAIL PROTECTED]
WhiteCrown Networks - More Than White Hats
Web Application Security - www.whitecrown.net
*/
----- 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
|
| --
| 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]
|
|
|
--
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]
