Hi, im trying to get a SELECT join statement workin. How the tables are organized are listed below

table articles


Table city_lookup

Table cities

On one page I am givin the aid in the variable $aid. With this I have to find out everything about this article, as well as what cities it applies to.
So I came up with this:

$result= mysql_query("SELECT * FROM articles, cities WHERE aid = '$aid' AND articles.aid=city_lookup.aid AND city_lookup.cid=cities.cid") //get all info in articles table
or die("Error");

But its not working, Im getting the error part
Hope soneone can help