Select values

[dreamwest]

Im trying to select an array of rows. I need to select all rows with different ids:

 

id | name

 

234 | name1

3    |name2

125  |name3

4  |name4

 

$query = "SELECT * FROM table WHERE id=(4,125) and  approve=1 ";

 

So im selecting everything from row 4 and 125....but syntax error

I cant think how to do it..

 

[roopurt18]

$query = "SELECT * FROM table WHERE id in (4,125) and  approve=1 ";

[dreamwest]

Sweet!  Thanks

 

I found another way too, would this way cause any problems

 

$query = "SELECT * FROM table WHERE (id=4 || id=125) and  approve=1 "; 

[roopurt18]

It won't cause problems.  But in SQL it's probably "more" correctly to use OR instead of ||

 

$query = "SELECT * FROM table WHERE (id=4 OR id=125) and  approve=1 ";

 

The IN( ... ) method is probably easier to code in PHP as well with arrays and implode.