Jump to content

SELECT specific MySQL rows


scrubbicus

Recommended Posts

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
?>

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.