Query Is Not Working

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
shafiq2626
Forum Commoner
Posts: 88
Joined: Wed Mar 04, 2009 1:54 am
Location: Lahore
Contact:

Query Is Not Working

Post by shafiq2626 »

Hi!
Please Help that how this query will work

Code: Select all

$queryBen = mysql_query("select m.cid,m.color,m.grade,m.sprice,m.mid,m.mdid,m.fid,m.tid,mak.mname,mod.mdname,ful.fname,tran.tname  from tbl_car m,maker mak,model mod,ftype ful,transmission tran where m.cid=$_SESSION[car_id] AND mak.mid=m.mid AND mod.mdid=m.mdid AND ful.fid=m.fid AND tran.tid=m.tid");
only this get first value $_SESSION[car_id] other are display with same name
pls help
iamngk
Forum Commoner
Posts: 50
Joined: Mon Jun 29, 2009 2:20 am

Re: Query Is Not Working

Post by iamngk »

use left join . try the following query

Code: Select all

 
$queryBen = mysql_query("select m.cid,m.color,m.grade,m.sprice,m.mid,m.mdid,m.fid,m.tid,mak.mname,mod.mdname,ful.fname,tran.tname  
from tbl_car m 
LEFT JOIN maker mak ON mak.mid=m.mid 
LEFT JOIN model mod ON mod.mdid=m.mdid 
LEFT JOIN ftype ful ON  ful.fid=m.fid 
LEFT JOIN transmission ON tran.tid=m.tid 
where m.cid=$_SESSION[car_id]");
 
Also check your loop where you are fetching result from resultset.
Post Reply