SELECT specific MySQL rows

[scrubbicus]

So I have an array of IDs that I would only like to select from a database table instead of everything in the table.

 

How might I go about doing that?

[PaulRyan]

By showing some code first...

 

Regards, PaulRyan.

[rondog]

there is many ways to go about it.

 

I haven't tested this, but something like this should work

<?php
$ids = array(1,2,3,5,9);

$sql = "SELECT * FROM table WHERE ";
foreach ($ids as $value)
{
$sql .= "id = " . $value . " or ";
}

$sql = substr($sql,0,-4);

echo $sql;
// SELECT * FROM table WHERE id = 1 or id = 2 or id = 3 or id = 5 or id = 9
?>

[Psycho]

there is many ways to go about it.

 

I haven't tested this, but something like this should work

<?php
$ids = array(1,2,3,5,9);

$sql = "SELECT * FROM table WHERE ";
foreach ($ids as $value)
{
$sql .= "id = " . $value . " or ";
}

$sql = substr($sql,0,-4);

echo $sql;
// SELECT * FROM table WHERE id = 1 or id = 2 or id = 3 or id = 5 or id = 9
?>

 

Yes, there are "many" ways, but that ^^ is not one of the "right" ways.

 

$stringOfIDs = implode(',', $arrayOfIDs);
$query = "SELECT * FROM [table_name] WHERE id IN {$stringOfIDs})";