[SOLVED] ORDER BY date

[ram4nd]

How can i do order by date the right way with this:

 

'SELECT * FROM links WHERE active = 1 AND subcat = '.$x.' ORDER BY date ASC LIMIT 0,10'

[rhodesa]

is the column called "date"? don't use a column named date, as it is a reserved word in MySQL...if it MUST be called date though, it would look like:

'SELECT * FROM links WHERE active = 1 AND subcat = '.$x.' ORDER BY `date` ASC LIMIT 0,10'

[ram4nd]

thank you, how stupid of me