prepare(‘SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour'); $sth->bindParam(‘calories’, $calories, PDO::PARAM_INT);
/* Names can be prefixed with colons “:” too (optional) */
$sth->bindParam(‘:colour’, $colour, PDO::PARAM_STR);
$sth->execute();
?>