Hi, Saturday, February 1, 2003, 2:00:51 PM, you wrote: PJN> I would like to list 2 possable items in a mysql queary.
PJN> SELECT * FROM products WHERE productType = '$productType AND Where PJN> productPublic = 'staff' OR productPublic = 'members' ORDER BY productId DESC PJN> LIMIT 10 PJN> I would like to display a list of the same products only if productPublic = PJN> staff or members. PJN> At the moment what i have just gives me the 1st 10 items. PJN> Any help you need brackets to sort out the logic SELECT * FROM products WHERE productType = '$productType AND (productPublic = 'staff' OR productPublic = 'members') ORDER BY productId DESC LIMIT 10 -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
