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

table articles

|--aid--|--article_headline--|--article_body--|--article_date-------|
|---1---|---whatever-------|--fdsafdsaf-----|--456784561-----|

Table city_lookup
|--aid--|--cid--|
|---1---|--1---|
|--1----|--3---|

Table cities
|--cid--|--city----|
|--1----|-Kelowna-|
|--2----|-vernon--|
|--3----|-seattle--|

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