Jump to content

[SOLVED] MySQL query


Ion_Cannon

Recommended Posts

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

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.