i did the points calculation already. but dont know to input it in the database? can anyone help me out?

$sql =”select * from tbl_predictions where user_id=”.$user_id;
$result =$db->readValues($sql);
$prediction_points = 0;

for($k=0;$kreadValues($sql);

$week_points = 0;
if(count($predictions)>0){

for($p=0;$preadValues(”select * from tbl_schedule where id_schedule=”.$predictions[$p]['match_id']);
$scorer_team1 = explode('^^^',$predictions[$p]['scorer1']);
$scorer_team2 = explode('^^^',$predictions[$p]['scorer2']);

$sql = (”select result from tbl_schedule where period='$week' and id_schedule=”.$predictions[$p]['match_id']);
$InsertedR = $db->readValues($sql);

$points = 0;

if($predictions[$p]['result']==$teams[0]['result']){

$points = $points+2;

}

if($predictions[$p]['scoreline1']==$teams[0]['team1_scoreline'] && $predictions[$p]['scoreline2']==$teams[0]['team2_scoreline']){

$points = $points+2;

}

if($predictions[$p]['goal1']==$teams[0]['team1_goals'] && $predictions[$p]['goal2']==$teams[0]['team2_goals']){

$points = $points+2;

}
if($predictions[$p]['redcard1']==$teams[0]['team1_cards'] && $predictions[$p]['redcard2']==$teams[0]['team2_cards']){

$points = $points+2;

}

$scorer1 = array();
$scorer2 = array();
$scorer3 = array();
$scorer4 = array();

$scorer1 = explode('^^^',$teams[0]['team1_scorer']);
$scorer2 = explode('^^^',$teams[0]['team2_scorer']);
$scorer3 = explode('^^^',$predictions[$p]['scorer1']);
$scorer4 = explode('^^^',$predictions[$p]['scorer2']);

$available = array_diff_assoc($scorer1, $scorer3);

#print_r($available);

$available1 = array_diff_assoc($scorer2, $scorer4);

#print_r($available1);

if(count($available)>0&&count($available1)>0){
$points = $points+2;
}

if ($InsertedR[0]['result'] == 0){

$points = 0;
}else{
$points = $points;

}

}

//echo $week.'==='.$week_points;
$week_points = $week_points+$points;

}

$prediction_points =$week_points+$prediction_points ;

// echo $total_points.'=====';

}

?>

How input the week_points into database now, since i have created column in mysql weekPoints. the data will be insert based on user_id per user. how to do it?

i did the points calculation already. but dont know to input it in the database? can anyone help me out?

$sql =”select * from tbl_predictions where user_id=”.$user_id;
$result =$db->readValues($sql);
$prediction_points = 0;

for($k=0;$kreadValues($sql);

$week_points = 0;
if(count($predictions)>0){

for($p=0;$preadValues(”select * from tbl_schedule where id_schedule=”.$predictions[$p]['match_id']);
$scorer_team1 = explode('^^^',$predictions[$p]['scorer1']);
$scorer_team2 = explode('^^^',$predictions[$p]['scorer2']);

$sql = (”select result from tbl_schedule where period='$week' and id_schedule=”.$predictions[$p]['match_id']);
$InsertedR = $db->readValues($sql);

$points = 0;

if($predictions[$p]['result']==$teams[0]['result']){

$points = $points+2;

}

if($predictions[$p]['scoreline1']==$teams[0]['team1_scoreline'] && $predictions[$p]['scoreline2']==$teams[0]['team2_scoreline']){

$points = $points+2;

}

if($predictions[$p]['goal1']==$teams[0]['team1_goals'] && $predictions[$p]['goal2']==$teams[0]['team2_goals']){

$points = $points+2;

}
if($predictions[$p]['redcard1']==$teams[0]['team1_cards'] && $predictions[$p]['redcard2']==$teams[0]['team2_cards']){

$points = $points+2;

}

$scorer1 = array();
$scorer2 = array();
$scorer3 = array();
$scorer4 = array();

$scorer1 = explode('^^^',$teams[0]['team1_scorer']);
$scorer2 = explode('^^^',$teams[0]['team2_scorer']);
$scorer3 = explode('^^^',$predictions[$p]['scorer1']);
$scorer4 = explode('^^^',$predictions[$p]['scorer2']);

$available = array_diff_assoc($scorer1, $scorer3);

#print_r($available);

$available1 = array_diff_assoc($scorer2, $scorer4);

#print_r($available1);

if(count($available)>0&&count($available1)>0){
$points = $points+2;
}

if ($InsertedR[0]['result'] == 0){

$points = 0;
}else{
$points = $points;

}

}

//echo $week.'==='.$week_points;
$week_points = $week_points+$points;

}

$prediction_points =$week_points+$prediction_points ;

// echo $total_points.'=====';

}

?>

How input the week_points into database now, since i have created column in mysql weekPoints. the data will be insert based on user_id per user. how to do it?

I just did it.

I used this:
SELECT count(products_id) as count_products , SUM( reviews_rating ) as total FROM TABLE WHERE products_id=”.$product_id;

I have table where i need SUM of a field as will as I have to COUNT total rows.

Any idea?