Floob Posted February 16, 2008 Posted February 16, 2008 Hi, Here are my versions: PHP version 4.4.7 MySQL version 4.1.22-standard I am getting this error: 1054 - Unknown column 'mydb_mydb.au.articles_id' in 'on clause' select count(*) as total from ((articles a) left join authors au using(authors_id)) left join articles_description ad using(articles_id), articles_to_topics a2t left join topics_description td using(topics_id) where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and ad.language_id = '1' and td.language_id = '1' Any ideas? Floob.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.