My SQL code is not inserting in the table. Does someone know what i do wrong?
SQL/PHP Code:
$ownerid = $input->FilterText($_GET['ownerId']);
$widgetid = $input->FilterText($_GET['ratingId']);
$rate = $input->FilterText($_GET['givenRate']);
}
if(is_numeric($ownerid) && is_numeric($widgetid) && is_numeric($rate)){
$myvote = $db->result($db->query("SELECT COUNT(*) FROM ".PREFIX."ratings WHERE raterid = '".$user->id."' AND userid = '".$ownerid."'"));
if($myvote < 1 && $ownerid != $user->id && $rate > 0 && $rate < 6){
$db->query("INSERT INTO cms_ratings (userid,rating,raterid) VALUES ('".$ownerid."','".$rate."','".$user->id."')");
}
Hope someone can help me with this problem. Its not inserting @ database.