Page 1 of 1

Pleas help convert queries from MySQL 4 to MySQL 5

Posted: Sat Jun 06, 2009 1:35 pm
by 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.

Code: Select all

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

Re: Pleas help convert queries from MySQL 4 to MySQL 5

Posted: Sat Jun 06, 2009 2:05 pm
by califdon
What error message are you receiving?

Re: Pleas help convert queries from MySQL 4 to MySQL 5

Posted: Sat Jun 06, 2009 2:43 pm
by mrban
i got only this "Invalid Entry." i dont know where else need to look

Code: Select all

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

Re: Pleas help convert queries from MySQL 4 to MySQL 5

Posted: Sat Jun 06, 2009 7:00 pm
by kalebaustin
Run that query in mysql command line, or php my admin and see what results, if any and what error message you get.

Re: Pleas help convert queries from MySQL 4 to MySQL 5

Posted: Sat Jun 06, 2009 8:22 pm
by califdon
Or do what I recommend that you ALWAYS do when getting a database access script working, use the PHP or die() syntax along with mysql_error() so you can see your error messages. Otherwise it's like trying to ski blindfolded! I recommend:

Code: Select all

$sql =  "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'";
$dbu->query($sql) or die(mysql_error());

Re: Pleas help convert queries from MySQL 4 to MySQL 5

Posted: Sun Jun 07, 2009 3:38 am
by mrban
i tested on phpmyadmin no errors but still not working and when i put this code

Code: Select all

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

Re: Pleas help convert queries from MySQL 4 to MySQL 5

Posted: Sun Jun 07, 2009 4:09 am
by onion2k
It's just returning the string you specified. You need to get the error that the database is returning. It'll be a method of your DB abstraction class $dbu. Read the documentation for it.

Re: Pleas help convert queries from MySQL 4 to MySQL 5

Posted: Sun Jun 07, 2009 8:12 am
by mrban
thank you everybody for help i fix it my self :lol: