I've got a very simple table:
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.
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;
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.
SELECT * FROM active_songs WHERE hide_from_chart != '1' ORDER BY 'song_title' ASC