Ion_Cannon Posted August 22, 2009 Share Posted August 22, 2009 Hello, having trouble with the following query, getting a parse error. I figure it is something with brackets that is the issue but I am not sure. Basically I am checking whether a customer has entered a previous order number correctly. $result_orderno = Db::getInstance()->getrow(' SELECT `id_order` FROM `'._DB_PREFIX_.'orders` WHERE `id_customer` = '.intval($customer_id) AND `id_order` = '.intval($oldorderno)); Thanks for any help. Link to comment https://forums.phpfreaks.com/topic/171373-solved-mysql-query/ Share on other sites More sharing options...
awpti Posted August 22, 2009 Share Posted August 22, 2009 $result_orderno = Db::getInstance()->getrow(' SELECT `id_order` FROM `'._DB_PREFIX_.'orders` WHERE `id_customer` = '.intval($customer_id).' AND `id_order` = '.intval($oldorderno)); Link to comment https://forums.phpfreaks.com/topic/171373-solved-mysql-query/#findComment-903758 Share on other sites More sharing options...
Ion_Cannon Posted August 23, 2009 Author Share Posted August 23, 2009 Thank you. knew it was something simple. Link to comment https://forums.phpfreaks.com/topic/171373-solved-mysql-query/#findComment-904710 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.