My hosting company uses MySQL 3.23.58, and I'm running PHP-Nuke 6.9 (if
you're not familiar with it; it's at http://www.phpnuke.org/).
At any rate, the problem I'm having is that PHP-Nuke uses a field to
store a "signed-up" date for each user, but, for some reason, it's just
a text field and no
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Works perfectly! Thanks!
Roger Baklund wrote:
| Yes, it can be done using the FIELD() function:
|
| SELECT * FROM tablename
| ORDER BY
| MID(datecol,8), # year
| FIELD(LEFT(datecol,3), # month
| 'Jan','Feb','Mar','Apr','May','
onth. I figured out how to fix it,
though. I just placed DESC after each item listed in the ORDER BY.
Ben Ramsey wrote:
| Works perfectly! Thanks!
|
| Roger Baklund wrote:
| | Yes, it can be done using the FIELD() function:
| |
| | SELECT * FROM tablename
| | ORDER BY
| | MID(dateco
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yeah, that was my mistake. Sorry about that. I've changed it to 9.
Roger Baklund wrote:
| * Paul DuBois
| [...]
|
|>>Jan 02, 2004
|
| [...]
|
|>By the way, why do you have MID(datecol,8) rather than MID(datecol,9)?
|
|
| There was no comma in the dat
