The sql is simple like:
SELECT artist_id
FROM artists
WHERE display_online = '1'
ORDER BY artist_id ACS
The statement works fine in phpMyAdmin and from the command line, but not
from my script, which uses PEAR::DB. It's as if PEAR just omitted the ORDER
BY statement.
Tony
On 3/13/07 5:24 PM,
Tony Grimes wrote:
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 t
too small a sort space on the server? have you checked the server config?
Bastien
From: Tony Grimes <[EMAIL PROTECTED]>
To: PHP-DB
Subject: [PHP-DB] MySQL sort stopped working
Date: Tue, 13 Mar 2007 13:22:25 -0600
I have this page that lists artists alphabetically:
http://www.wallacegalleri
