没有结果显示Mysqli

Question

I have this query which is one of a number of queries I have done, All the other queries works great but this does not display any results. My database has results that meets the request. Someone tell me what could be wrong?

<?php include_once "/phpmysqli/config.php" ?>
<?php 
$Week_ID = $teams->WeekID->CurrentValue;
$GKB = $teams->Keeper2->CurrentValue;
$stmt16 = mysqli_stmt_init($conn);
    if (mysqli_stmt_prepare($stmt16,"SELECT Total_pts FROM keeper_points WHERE PlayerID=? AND WeekNo=?"))
    {
      mysqli_stmt_bind_param($stmt16,"ss",$GKB,$Week_ID);
      mysqli_stmt_execute($stmt16);
      mysqli_stmt_bind_result($stmt16,$GKB_pts);
      mysqli_stmt_fetch($stmt16);
      echo $GKB_pts;
      mysqli_stmt_close($stmt16);
     }
?>

Answer 1

It sounds like PlayerID and WeekNo columns may be integers. If they are, then try passing in the parameters as so:

mysqli_stmt_bind_param($stmt16,"ii",$GKB,$Week_ID);