How to run multiple queries as array

Question

I got a PHP script that I need to run several queries of the same thing just different parameters, like:

SELECT * 
FROM Weather_records 
WHERE type = 1, 

SELECT * 
FROM Weather_records 
WHERE type = 2

Is there a way to run this as one query and just put it in a array or something?

there are several ways, depending on what you want to achieve. From views, a loop, a where type IN, ... too many options and possibilities here! — Jeff
– Jeff, Commented Jun 22, 2017 at 0:50
its for view, I know I could just use a loop but I'm doing like 12 quarries — Red Dragon
– Red Dragon, Commented Jun 22, 2017 at 1:10

sumit · Accepted Answer · 2017-06-22 00:51:42Z

6

Use IN

SELECT * FROM Weather_records WHERE type IN (1,2)

answered Jun 22, 2017 at 0:51

sumit

15.5k14 gold badges75 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

For ranges you can do WHERE type BETWEEN 1 AND 2.

Well I will need to do something with each record. So how do I take this query and get each record from it separately?

Red Dragon · Accepted Answer · 2017-07-20 01:57:51Z

0

I was looking at the problem wrong and ended up using one query to get the whole table and then used a loop and a switch case.

answered Jul 20, 2017 at 1:57

Red Dragon

436 bronze badges