Brazzan

Having a bit of a problem with looping the bindParam in a foreach. If I only have one statement, the function returns correct data, but if I add another "money => 999" the function returns a empty array. Can't one loop bindParam in this way? Second question is... I would love to scip the second loop and do the bindParam in the first one... possible? <?php function dbSelect($table, $query) { require_once ("../db/connect.php"); foreach($query as $id => $value) { $dbQuery .= $id." = :".$id.' AND '; } $dbQuery = substr($dbQuery, 0, -5); $do = $db_connect->prepare ("SELECT * FROM $table WHERE $dbQuery"); foreach($query as $id => $value) { $do->bindParam(":".$id, $value, PDO::PARAM_INT); } $do->execute(); $result = $do->fetchAll(); return $result; } $dbResult = dbSelect("test", $where = array( "id" => 1, "money" => 999, ) ); echo "<xmp>".print_r($dbResult, true)."</xmp>"; ?> If I skip money => 999, the result returns correctly. Array ( [0] => Array ( [id] => 1 [0] => 1 [name] => Look at me! [1] => Look at me! [money] => 999 [2] => 999 [id2] => 2 [3] => 2 ) ) But if I add money => 999 Array ( )