2009/7/10 Shiro Njagi <sheeroh@gmail.com>

Hello all...

I have a slight problem with a certain page.
I have five tables: listing, towns, buildings, categories and sub-categories.

The page that i wish to display will show the listings form the listing table in the database.
The listing table contains a categoryid, subcategoryid, buildingid and townid.
I would like to display all these fields as names, hence the need for the join.
However, a sub-category may be null, hence the need for the left join.

I created the query below which is returning no data.
For the life of me, I can't diagnose the problem...
HELP!!

$query_listing = "SELECT * FROM buildings, categories, towns, listing LEFT JOIN subcategories ON listing.listingcategory=subcategories.subcategoryid WHERE buildings.buildingid=listing.listingbuildingid AND categories.categoryid=listing.listingcategory AND towns.townid=listing.listingtownid";

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
Other services @ http://my.co.ke
Other lists
-------------
Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general