Query Returning Empty

[ricmetal]

hi y'all,

i am getting empty strings when making a query.

what can i do to troubleshoot this problem?

 

this is the code

if($stmt = $mysqli->prepare("SELECT user_email FROM users WHERE id = ? ")) {
$stmt->bind_param('i', $id);
$stmt->execute();
$stmt->bind_result($isActivated);
echo $isActivated; // outputs empty
die();

Edited September 25, 2012 by ricmetal

[PFMaBiSmAd]

After you bind the result to the variable, you must execute $stmt->fetch(); to actually fetch the row of data from the result set.

[ricmetal]

to many awake hours you know?

thanks man