also, if you're using PDO:
$stmt = $dbh->prepare( 'SELECT foo, bar from fooBar where foo = :fooValue' ); $stmt->bind( ':fooValue', $foo ); $stmt->execute();
$stmt = $dbh->prepare( 'SELECT foo, bar from fooBar where foo = :fooValue' ); $stmt->bind( ':fooValue', $foo ); $stmt->execute();
$stmt = $dbh->prepare( 'SELECT foo, bar from fooBar where foo = ?' );
$stmt->execute($foo);
The only case where using named parameters is really useful is when there are so many parameters you're reduced to counting question marks.