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

[123GoToAndPlay]

Hi

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

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


this ofcourse doesn't work

[Gaffer Sports]

Hi

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

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


this ofcourse doesn't work


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


This should work for you.

Steve

[123GoToAndPlay]

@gaffersports,

well I found this one

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


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 .= ")";


gives me

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


need to get rid of the ,

certainly going to try your suggestions as well.

[123GoToAndPlay]

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;


Not very elegant but that will be next I guess.

[123GoToAndPlay]

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).")";

[onlywin]

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

[luizeba]

Are you sure it works, onlywin?

[mwasif]

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