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!
$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'");
$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.");
}
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:
$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());
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.