Log in

View Full Version : Resolved Prepared statement bind_param() count



crobinson42
09-18-2012, 05:49 AM
What am i doing wrong?!


$user->getUserRegions($uid);


function getUserRegions($uid){
global $mysqli;

$stmt=$mysqli->prepare("SELECT user_region.default, company_region.name FROM user_region, company_region WHERE user_region.region=company_region.id AND user_region.user=?");
$stmt->bind_param($uid);
$stmt->execute();
$stmt->bind_result($rdef,$rname);
while($stmt->fetch()){
echo $rname.'<br>';
}
$stmt->close();
}


Warning: Wrong parameter count for mysqli_stmt::bind_param()

This is killing me! any help is appreciated.