MySQL sort stopped working
| From: | Tony Grimes | Date: | Tue, 13 Mar 2007 19:22:25 +0000 |
| Subject: | MySQL sort stopped working | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-43271@lists.php.net to get a copy of this message | ||
I have this page that lists artists alphabetically:
http://www.wallacegalleries.com/artists.php
At least it did until today. Nobody made any changes to the files, but the
database stopped sorting by artist_id. The list shown is just the default
order that mysql spits out if the SORT BY clause is omitted (as if I clicked
'browse' in phpMyAdmin).
The SQL works in phpMyAdmin, and the site uses PEAR::DB. We patched the
server last week, but the problem showed up this morning.
Anyone have any ideas on what could be causing this?
Thanks in advance,
Tony