1064: 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 amount<>''' at line 4 SQL:
SELECT COUNT(*)
FROM item_payments AS ip
INNER JOIN items AS i ON ip.itemid = i.itemID
WHERE ip.sc_mem_id = AND amount<>'' 1064: 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 amount<>'' ORDER BY transactiondate DESC LIMIT 0, 10' at line 4 SQL:
SELECT ip.transactiondate, ip.transactionid, ip.amount, ip.currency, ip.paymentid, i.ItemShortDesc, ip.itemid
FROM item_payments AS ip
INNER JOIN items AS i ON ip.itemid = i.itemID
WHERE ip.sc_mem_id = AND amount<>'' ORDER BY transactiondate DESC LIMIT 0, 10