Query failed : SELECT products.genericof,sp.recordID, sp.extension,sp.strength, sp.type, sp.quantity, sp.price, sp.foreigndrugname, os.supplier 

			FROM tbl_stockpricing AS sp, tbl_offshoresuppliers as os ,tbl_products as products

			WHERE  products.recordID= AND  sp.productBridge= AND os.recordID=sp.supplierBridge ORDER BY cast(strength as unsigned),cast(substring_index(strength,'/',-1)as unsigned), cast(quantity as unsigned) <br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND  sp.productBridge= AND os.recordID=sp.supplierBridge ORDER BY cast(strength ' at line 5