It might be that I've just made a mistake in the query but is it possible to do a mysql_fetch_assoc on the result of a query which joins 2 tables?