PHP
-
SELECT ord.orderid,cus.custid,cus.custname,cat.catid,cat.catname,pro.proid,pro.proname from `order` as ord inner join`customer` as cus on cus.custid=ord.custid inner join `category` as cat on cat.catid=ord.catid inner join `product` as pro on pro.proid=ord.proid there is no error in this query bt still it select no record i dnt know y:(
-
SELECT ord.orderid,cus.custid,cus.custname,cat.catid,cat.catname,pro.proid,pro.proname from `order` as ord inner join`customer` as cus on cus.custid=ord.custid inner join `category` as cat on cat.catid=ord.catid inner join `product` as pro on pro.proid=ord.proid there is no error in this query bt still it select no record i dnt know y:(
If no error & no data again your query, there's no matching records for your query(criterias). You have to check the query on all ways. First with out any criteria/JOINs (
SELECT * FROM Table) And add a criteria/JOIN (SELECT * FROM Table WHERE Column1 = 'Value1') And add ...... (SELECT * FROM Table WHERE Column1 = 'Value1' AND Column2 = 'Value2') Try it yourself.thatraja
Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute