Is it possible to have a multiple select in one query?

Hi

Is it possible to have a multiple select in one query like

SELECT * FROM images WHERE id = 8, 10, 4

Code (markup):

this ofcourse doesn't work

 

SELECT * FROM images WHERE id = 8 OR id = 10 OR id = 4

Code (markup):

This should work for you.

Steve

 

@gaffersports,

well I found this one

SELECT * FROM images WHERE id IN(8,10,4)

Code (markup):

Never used IN before so this will be the first time

Now I am stuck with the php part

$sql = "SELECT * FROM images WHERE id IN (";
	foreach($ids_today as $id_today )
	{
	   $sql .= ",$id_today";
	  } 
	  $sql .= ")";

Code (markup):

gives me

SELECT * FROM images WHERE id IN(,8,10,4)

Code (markup):

need to get rid of the ,

certainly going to try your suggestions as well.

 

ok with implode I have it up and running

$tmp_ids = array();
	 $sql = "SELECT * FROM images WHERE id IN (";
	foreach($ids_today as $id_today )
	{
	   $tmps_ids[] = $id_today;
	  } 
	  $sql .= implode(",", $tmps_ids);
	  $sql .= ")";

	  echo $sql;	

Code (markup):

Not very elegant but that will be next I guess.

 

oh rewritten it to

$tmp_ids = array();
    foreach($ids_today as $id_today )
    {
       $tmps_ids[] = $id_today;
  }
     
      $sql = "SELECT * FROM images WHERE id IN (".implode(",", $tmps_ids).")";

Code (markup):

 

yes, I paste your version and a version that works:

your version: SELECT * FROM images WHERE id = 8, 10, 4

correct: SELECT * FROM images WHERE id = 8 OR id = 10 OR id= 4

 

Are you sure it works, onlywin?

 

This is quite an old thread. Didn't you notice that the poster already posted the solution?