Jump to content

Query String Problem


paul2463

Recommended Posts

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
Link to comment
https://forums.phpfreaks.com/topic/25970-query-string-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.