<?php
$re = $conn->prepare("SELECT * FROM resultado");
$re->execute();

$pr = $conn->prepare("SELECT * FROM prediccion");
$pr->execute();

$ca = $conn->prepare("SELECT * FROM calculo");
$ca->execute();

$fe = $conn->prepare("SELECT * FROM fecha WHERE estado=1");
$fe->execute();

?>

<form action="tag.php" method="post">
  <?php foreach ($ca as $c){
    if (($c['nFecha'])==($f['numero_fecha'])){
    foreach ($pr as $p) { ?>
  <?php if ((($p['id_fecha'])==($c['nFecha']))&&(($r['id_fecha'])==($p['id_fecha']))&&(($p['id_usuario'])==($c['id_us']))){
    $s=0;
    if(($p['valorL1'] == $r['valorL1']) && ($p['valorV1'] == $r['valorV1'])) {
        $s= ($s+3);
      } elseif(($p['valorL1'] > $r['valorV1']) && ($p['valorL1'] > $p['valorV1'])) {
        $s= ($s+1);
      }  elseif(($p['valorL1'] < $r['valorV1']) && ($p['valorL1'] < $p['valorV1'])) {
        $s= ($s+1);
      }  elseif(($r['valorL1'] == $r['valorV1']) && ($p['valorL1'] == $p['valorV1']) && ($r['valorL1'] <> $p['valorL1'])) {
        $s= ($s+1);
      }  else {
        $s= ($s+0);
     }

     }}?>
    <input type="hidden" name="puntaje_fecha[]" value="<?php echo $s; ?>">
    <?php }?>
  <input type="hidden" name="id_calculo[]" value="<?php echo $c['id_calculo']; ?>">
  <?php  }?>

  <input type="submit" value="Actualiza puntos">
</form>