Mit temporären Tabellen kann man das ganz elegant lösen
PHP-Code:
sql: "DROP TABLE IF EXISTS temp;";
sql: "CREATE TEMPORARY TABLE IF NOT EXISTS temp (id INT(10) );";
$ids = array(1,2,3,4);
$insert = " (" . join("), (", $ids) . ") ";
sql: "INSERT INTO temp (id) VALUES $insert;";
sql: "SELECT tabelle.id, tabelle....
FROM temp
LEFT JOIN tabelle
ON (temp.id = tabelle.id)
ORDER BY ...;";