Page 1 of 1

Query Is Not Working

Posted: Thu Jul 09, 2009 5:53 am
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

Re: Query Is Not Working

Posted: Thu Jul 09, 2009 6:11 am
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.