paul2463 Posted November 2, 2006 Share Posted November 2, 2006 Hello, I have a function which works wonderfully...at times..it draws a datagrid from a query..the function call is as follows[code]$MyGrid= new classDatagrid;$MyGrid->set_query($querytext,$primaryKey);[/code]when i pass it the following query it works brilliantly[code]$query = "SELECT products.idproducts as prod, prodstatus.staType as stock, products.codeProd as code, products.nameProd as products, prodcat.nameCat as catagory, supplier.company as company, products.qtyProd as quantity FROM ((((prodstatus LEFT JOIN products ON products.prodStatus_idprodStatus=prodstatus.idprodStatus) LEFT JOIN prodcat ON prodcat.idprodCat=products.prodCat_idprodCat) LEFT JOIN subprodcat ON subprodcat.idsubProdCat=products.subProdCat_idsubProdCat)LEFT JOIN supplier ON supplier.idsupplier=products.supplier_idsupplier)";$MyGrid->set_query($query,'prod');[/code]and when i pass it this ammended query it also works[code]$query = "SELECT products.idproducts as prod, prodstatus.staType as stock, products.codeProd as code, products.nameProd as products, prodcat.nameCat as catagory, supplier.company as company, products.qtyProd as quantity FROM ((((prodstatus LEFT JOIN products ON products.prodStatus_idprodStatus=prodstatus.idprodStatus) LEFT JOIN prodcat ON prodcat.idprodCat=products.prodCat_idprodCat) LEFT JOIN subprodcat ON subprodcat.idsubProdCat=products.subProdCat_idsubProdCat)LEFT JOIN supplier ON supplier.idsupplier=products.supplier_idsupplier) WHERE products.codeProd = 'Bathroom'";$MyGrid->set_query($query,'prod');[/code]but if i do this ( because i have to do make up the query based on certain factors)[code]$query = "SELECT products.idproducts as prod, prodstatus.staType as stock, products.codeProd as code, products.nameProd as products, prodcat.nameCat as catagory, supplier.company as company, products.qtyProd as quantity FROM ((((prodstatus LEFT JOIN products ON products.prodStatus_idprodStatus=prodstatus.idprodStatus) LEFT JOIN prodcat ON prodcat.idprodCat=products.prodCat_idprodCat) LEFT JOIN subprodcat ON subprodcat.idsubProdCat=products.subProdCat_idsubProdCat)LEFT JOIN supplier ON supplier.idsupplier=products.supplier_idsupplier)";$text = "WHERE products.codeProd = 'Bathroom'"; //this information is passed by $_GET$querytext = "$query$text";$MyGrid->set_query($querytext,'prod');[/code]it fails miserably and does nothing, any ideas that I have missed completely Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.