Mulitple query results!

intermediate

how do i ask for multiple results in a mysql query.

ex: $query = "select * from $table where id='1'";

there i asked in the query for it to retrieve all of the rows in the database where the id is 1. how would i ask it to give back multiple things like in one query statement ask it to give me back all rows where id='1' and id='3' and id='6' just as an example.

plz help =(

nemonoman

You would use the OR construct in your WHERE clause:

SELECT * FROM sometable
WHERE id = 1
OR id = 3
OR id = 6
OR someothercolumn=yetanothercolumn
OR (happy='TRUE' AND worry='FALSE')

etc.

Good luck.

lukemedway

Hmm, it is kindda hard to know exactly what you mean, but you can do...

$query = "SELECT * FROM $table WHERE id = $id";

The variable id according to what you output on the page.

$query = "SELECT * FROM $table WHERE aid = 1 AND bid = 2 AND cid = 5";

and then of course each number can be a var.

nemonoman

Hi. I'd be careful to consider the difference between AND and OR in a SQL WHERE clause.

Assuming the id column is a unique integer:

WHERE id=1 AND id=2

would produce 0 results

WHERE id = 1 OR id = 2

would produce 2 results.

OR means -- if ANY of the conditions are met select the row.

AND means -- if ALL of the conditions are met, select the row.

mahendrakalkura

go with OR

AND wont work

nemonoman

Here's another useful construct:

SELECT * FROM table
WHERE id IN (1, 2, 6)

IN finds any record that matches ANY of the target parameters -- it's a sort of giant OR ..

cgraz

Yeah, IN works awesome--saves a lot of time. Here's some good reading on it.

http://sqlcourse2.com/setoper.html

Cgraz