FUNKAM35 Posted June 5, 2015 Share Posted June 5, 2015 Hi, I need to do a multiple select eg select * FROM stock WHERE and then it will be where (width=100 AND size=50 AND profile=20) OR (width=50 AND size=120 AND profile =30) OR (width=30 AND size=40 AND profile=70) How would I do this? many thanks Quote Link to comment https://forums.phpfreaks.com/topic/296666-multiple-variable-select/ Share on other sites More sharing options...
cyberRobot Posted June 5, 2015 Share Posted June 5, 2015 It sounds like you pretty much have it covered with that pseudo code. Do you have a query that's not working? Perhaps the fourth example found in the following article will help: http://www.techonthenet.com/mysql/where.php Quote Link to comment https://forums.phpfreaks.com/topic/296666-multiple-variable-select/#findComment-1513286 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.