I’ve got a very simple table:
CREATE TABLE `active_songs` (
`id` int(11) NOT NULL auto_increment,
`song_title` varchar(255) default NULL,
`artist_name` varchar(255) default NULL,
`label` varchar(255) default NULL,
`hide_from_chart` varchar(255) default NULL,
`created` datetime default NULL,
`created_week` int(11) default NULL,
`user_added` tinyint(4) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
And when I run a simple SELECT on it with an ORDER BY directive it doesn’t order by the field I specify. It is only ordering by the ID field.
SELECT * FROM active_songs WHERE hide_from_chart != '1' ORDER BY 'song_title' ASC
The query above should output the song list and order them by song title (obviously) but it’s outputting them by ID no matter what. No errors are being thrown.
Thanks