Posted by sugapablo on 08/29/07 00:41

Here's my code:

<?php
$mysqli = new mysqli("localhost", "****", "********", "***********");

$idNum = "1030";

$sql = "select id,email from users where id > ?;";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('s', $idNum);
$stmt->execute();

$stmt->bind_result($id, $email);

while ($stmt->fetch()) {
printf ("%s (%s)<br/>\n", $id, $email);
}
?>

Obviously, what this should do is bind $idNum (value of 1030) to the
SQL statement and send this to the MySQL server -> select id,email
from users where id > '1030'; This should return 10 rows.

However, this is not what's happening. What's happening is that the
variable is not being binded and this is being sent -> select id,email
from users where id > ''; And because of this, it's returning 1040
rows.

I've tested this on many different scenarios. No matter what I do,
the variables are not binding.

Any idea why this could be happening? I'm assuming it's a server
config issue. Even if you can think of more than one reason, can I
hear some possibilities? I'm at a loss!

[Back to original message]