Re: [PHP-DB] SQL syntax

2013-01-15 Thread Karl DeSaulniers
On Jan 15, 2013, at 5:25 AM, Amit Tandon wrote: SELECT orderid FROM ORDERS_TABLE WHERE orderstatus IN ( 'Cancelled', 'New'", 'Denied', 'Expired' , 'Failed' , 'Pending' , 'Refunded' , 'Reversed' , 'Under Review' , 'Voided') AND orderdate < '".mysqli_real_escape_s

Re: [PHP-DB] SQL syntax

2013-01-15 Thread Amit Tandon
SELECT orderid FROM ORDERS_TABLE WHERE orderstatus IN ( 'Cancelled', 'New'", 'Denied', 'Expired' , 'Failed' , 'Pending' , 'Refunded' , 'Reversed' , 'Under Review' , 'Voided') AND orderdate < '".mysqli_real_escape_string($ yesterday); Another option would be to use e

Re: [PHP-DB] sql syntax error

2003-01-29 Thread 1LT John W. Holmes
- Original Message - From: "Addison Ellis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 10:46 PM Subject: [PHP-DB] sql syntax error > hello, > i can not pinpoint this. your time and help is very much > appreciated. best, addison > > Error: > id=, HTTP_POS