What's wrong with my Left Join query??

[lizzyd]

Hello!

Just wondering if anyone can tell me if there's anything technically wrong with my left join query below?

$query = "SELECT h.EstablishmentName,h.RoomsFrom,h.NumBedrooms,h.EstablishmentType,h.Address1,h.Address2,h.Town,h.County,h.DescriptionEnglish,h.LongDescriptionEnglish,h.Hotel_Id,h.Region,h.AARating,h.RACRating,h.AirportName,h.AirportHotel FROM hotel h LEFT JOIN amenities a ON h.Hotel_Id=a.Hotel_Id WHERE MATCH (h.Town,h.DescriptionEnglish,a.Amenities) AGAINST ('$keywords' IN BOOLEAN MODE) ORDER BY $sortBy LIMIT $offset, $limit"; 

$result = mysql_query($query)
	or die ("Couldn't execute query");

Basically almost all my info is in my hotel table. My amenities table has just two columns - Hotel_Id and Amenities.

I'm just getting the Couldn't Execute Query message all the time and I'm trying to find out what I'm doing wrong!

LizzyD

[RossC0]

Try - the SQL statement in phpmyadmin or similar - then you get a clearer error message.

Most likely a syntax problem.

Also - try: FROM hotel AS h etc..

[lizzyd]

Cheers RossCO - good idea. Although just tried it and it all works perfectly in phpmyadmin. I'll keep scrutinising my code - I'm sure I'll find the error somewhere! Cheers!

LizzyD

[RossC0]

Bummer - try changing your die statement:

$result = mysql_query($query)
if (!$result)
{
die ($result->ErrorMsg());
}

[lizzyd]

no joy i'm afraid. thanks anyway - i'll keep trying!