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'");
     	

[bradgrafelman]

What's the error message returned from the SQL server?

[mrban]

i got only this "Invalid Entry." i dont know where else need to look

$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'");
    if(!$dbu->move_next())
    {
	   	unset($ft);
		return get_error_message("Invalid Entry.");
    }

[bradgrafelman]

What class are you using for $dbu?

[mrban]

$dbu=new mysql_db;

i tested on phpmyadmin this

$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'");

no errors,

but still no working and i put this code

if(!$dbu->move_next())
    {
   	unset($ft);
	return get_error_message("Invalid Entry.");
}

i get invalid entry

[Bjom]

check on the variables that provide the parameters, i.e. $glob, and $now

your SQL seems to execute ok BUT you don't get a result back. That in turn means: most likely something is wrong with the parameters.

Try this: replace the variables with fixed values, that you know will work, until you get a result, then re-add the variables one at a time. Oh and either use a debugger that shows you the variable's values or throw in a few var_dump or echo statements for the variables

[mrban]

thank you everybody for help i fix it my self