mysqli prepared statements ... don't get any results

[Epimetheus1980]

I'm trying to work with prepared statements, but unfortunately I do not get any result back. I also tried while($stmt->fetch()) { ... }, with the same effect. 

 

Does anyone have a suggestion?

 

Thanks in advance.

<?php
MAKING CONNECTION

if ($stmt = $mysqli->prepare("SELECT year FROM SOMETABLE WHERE id = ? LIMIT 1")) {

    $id = $_GET['id'];
    
    $stmt->bind_param("i", $id);
    
    
    $stmt->execute();
    
    
    $stmt->bind_result($year);
    
    $stmt->fetch();
    
    echo $year;
        
    
    $stmt->close();
}
$mysqli->close();

?>

[cyberRobot]

Have you checked if there are any MySQL errors? Try adding the following debug line before closing the database connection:

 

echo $mysqli->error;