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
