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 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 Link to comment https://forums.phpfreaks.com/topic/296666-multiple-variable-select/#findComment-1513286 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.