Pleas help convert queries from MySQL 4 to MySQL 5

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mrban
Forum Newbie
Posts: 4
Joined: Sat Jun 06, 2009 1:19 pm

Pleas help convert queries from MySQL 4 to MySQL 5

Post 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'"); 
 
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

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

Post by califdon »

What error message are you receiving?
mrban
Forum Newbie
Posts: 4
Joined: Sat Jun 06, 2009 1:19 pm

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

Post 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.");
    }
 
kalebaustin
Forum Newbie
Posts: 12
Joined: Mon Nov 19, 2007 11:28 am

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

Post 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.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

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

Post 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());
mrban
Forum Newbie
Posts: 4
Joined: Sat Jun 06, 2009 1:19 pm

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

Post 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."
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

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

Post 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.
mrban
Forum Newbie
Posts: 4
Joined: Sat Jun 06, 2009 1:19 pm

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

Post by mrban »

thank you everybody for help i fix it my self :lol:
Post Reply