Litewarez Tip : (Sql Selecting multiple ids with one query)

[litewarez]

Heya ,

What ill show you now is just a simple tip that you should be using in your websites if you are already not!

No the old fasioned way of selecting ids is to do a foreach loops like so

foreach($ids as $id){
    //Delete $id or Select $id here
}

This causes multiple queries but the best way to do this with one query is by using the mysql WHERE IN Clause like below

$ids = array(22,47,121); // this can be from $_POST
$query = "SELECT title FROM mytable WHERE id IN (".implode(",",$ids).")";

mysql_query($query); 

No the mysql resource that is returned will have them rows in it and only taken 1 query

Hope you all like this lil tip

litewarez Reviewed by litewarez on 26th Oct 2009. Litewarez Tip : (Sql Selecting multiple ids with one query) Heya :), What ill show you now is just a simple tip that you should be using in your websites if you are already not! No the old fasioned way of selecting ids is to do a foreach loops like so foreach($ids as $id){ //Delete $id or Select $id here } Rating: 5

[ddlshack]

This would not work because implode($ids) would evaluate to 2247121

[litewarez]

lol whoops i forgot the first argument for implode!... fixed now lol

[SplitIce]

If you are doing less than 3 items it is more efficient to use multiple AND ... statements btw

[ddlshack]

lol whoops i forgot the first argument for implode!... fixed now lol

Ahh, cool. I never knew you could do that with mysql . I just thought 'IN' was for subqueries