Pleas help convert queries from MySQL 4 to MySQL 5

[mrban]

Please help my whit this code i can find what need to change , spend all day and nothing.

it works on mysql 4, in version 5 it does not.

$dbu->query("select distinct car.*, type.name as type_name, make.name as make_name, member.dealership as member_dealership, member.member_type as member_member_type, member.first_name as member_first_name, member.phone as member_phone, member.city as member_city, market_segment.name as market_segment_name from car
inner join type on car.type=type.type_id
inner join market_segment on car.market_segment=market_segment.market_segment_id
inner join make on car.make=make.make_id
inner join member on car.member_id=member.member_id
where car.car_id='".$glob['car_id']."' and car.exp_date > '".$now."' and car.active1='1'");

   

[Maq]

What are the errors you're receiving?