member discount in Powerstore
Hi Ray,
I'm trying to implement a feature where member discounts are offered to customers when they register. That is, since Powerstore has a user registration, I want to implement a feature where registered used (members) can be offered a "member Discount" when they purchase an item.
Also I notice that, after, after I tried to add a member discount rule ( in order to properly keep track of the discount price for each item added to the shopping cart), I get the following SQL syntax error
Recordset: WADAProducts
ID Column: MySQL Error#: 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 '' at line 2.
I tried to update the SQL like you suggested in one of your earlier suggestion, that is,
SELECT * FROM products WHERE ProductID = %s OR ( -1= %s AND ProductID= %s) AND ProductLive <> 0
But that does not work.
Unless you're saying that, to implement a member discount for registered users in PowerStore, there's a different process?