I am trying to run this query
but it is giving me this error
Code:SQL ERROR [ mysqli ] Unknown column 'AL' in 'where clause'  SQL SELECT a.*, u.user_id, u.username, u.user_colour from phpbb_classifieds a, phpbb_users u WHERE u.user_id = a.ad_poster_id and a.state = AL and a.ad_expire > 1242052562 ORDER BY a.ad_date DESC LIMIT 10
I cant figure out why it is doing this, any ideas?