Forum Moderators: open
This query works...
"SELECT accommodation.id,
accommodation.name,
accommodation.name_fix,
accommodation.address,
accommodation.address2,
accommodation.postcode,
accommodation.tel,
accommodation.fax,
accommodation.url,
accommodation.email,
accommodation.price,
accommodation.price_type,
accommodation.rooms,
accommodation.rating,
accommodation.short_desc,
accommodation.long_desc,
accommodation.water,
accommodation.pets,
accommodation.type_id_fk,
l.name as location,
type.type
FROM accommodation, location as l, type
WHERE accommodation.location_id_fk = l.id
and type.id = accommodation.type_id_fk
AND accommodation.active like ".'"yes"'."
AND l.name_fix like '%$name%'"
This one doesn't, with a left join.
"SELECT accommodation.id,
accommodation.name,
accommodation.name_fix,
accommodation.address,
accommodation.address2,
accommodation.postcode,
accommodation.tel,
accommodation.fax,
accommodation.url,
accommodation.email,
accommodation.price,
accommodation.price_type,
accommodation.rooms,
accommodation.rating,
accommodation.short_desc,
accommodation.long_desc,
accommodation.water,
accommodation.pets,
accommodation.type_id_fk,
l.name as location,
type.type
FROM accommodation, location as l
left join type on (type.id = accommodation.type_id_fk)
WHERE accommodation.location_id_fk = l.id
AND accommodation.active like ".'"yes"'."
AND l.name_fix like '%$name%'"
anybody have any ideas? Please ? :-)
It should look like this:
..
...
FROM accommodation JOIN location AS l
ON accommodation.location_id_fk = l.id
LEFT JOIN type
ON type.id = accommodation.type_id_fk
WHERE accommodation.active like ".'"yes"'."
AND l.name_fix like '%$name%'"
Today you can use either method, but you can't mix them in the same FROM clause.
