Mysqli question

[Arek]

$stmt = $mysqli->prepare('SELECT user_name from `user_details` where user_email = ?');
  	 $stmt->bind_param('s', $var);
  	 $stmt->execute() or $this->myerror[] = $stmt->error; 

 

Any idea why this wont work, and wont give a error?

[Toppy]

The code is fine. It'll work if you're connected to the DB, SQL fields are correct and of course $var contains an email address. Try grabbing the results after the binding execute:

 

$stmt = $mysqli->prepare('SELECT user_name from `user_details` where user_email = ?');
$stmt->bind_param('s', $var);
$stmt->execute() or $this->myerror[] = $stmt->error;

$stmt->bind_result($user_name);
while ($stmt->fetch()) { 
   printf("Username is: %s \n", $user_name); 
}

[Arek]

Hey

Hey, the sql was fine but there was a error, i dident user $stmt->store_result to save it. Dont see how this helps when programming but it fixed it anyway :)