LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (http://www.linuxquestions.org/questions/programming-9/)
-   -   SQL: multiple WHERE statements (http://www.linuxquestions.org/questions/programming-9/sql-multiple-where-statements-566039/)

elvijs 07-02-2007 09:07 AM

SQL: multiple WHERE statements
 
Is something like this possible in a "clean" way?

SELECT * FROM table WHERE id = '1' OR id = '11' OR id = '9' OR id = '4' OR id = '6'
and so on...

For example I want to select information only about particular records (using PHP). I have an array with the records' ids (the size of array is unknown). Can I do something like this or is it impossible?

SELECT * FROM table WHERE id = '$array';

Guttorm 07-02-2007 09:09 AM

Hi

Try this:
PHP Code:

$ids join(",",$array);
$sql "SELECT * FROM table WHERE id IN ($ids)"


elvijs 07-02-2007 09:17 AM

Really thanks, it works.


All times are GMT -5. The time now is 06:15 PM.