prepare($query) or die "Can't prepare query: $query\n";
$res->execute or die "Can't execute query: $query\n";
$res=$res->fetchrow_hashref();
$name_turnir=$res->{name};
$query="SELECT id_match, gol1, gol2 FROM prognoz WHERE id_player=".$DB->quote($ENV{REMOTE_USER});
$result=$DB->prepare($query) or die "Can't prepare query: $query\n";
$result->execute or die "Can't execute query: $query\n";
while (my $hashref = $result->fetchrow_hashref) {
$voted{$hashref->{id_match}}->{gol1}=$hashref->{gol1};
$voted{$hashref->{id_match}}->{gol2}=$hashref->{gol2};
}
#print "time_now".$time_now1."
".$input{id_turnir}."
";
#$query="SELECT MAX(igra.to_show), igra.time FROM igra, tur WHERE igra.time<=$time_now1 AND igra.id_tur=tur.id AND tur.id_turnir=$input{id_turnir} GROUP BY igra.time ORDER BY igra.to_show ASC";
# print $query."
";
#$result=$DB->prepare($query) or die "Can't prepare query: $query\n";
#$result->execute or die "Can't execute query: $query\n";
#while (my $hashref = $result->fetchrow_hashref) {
# print "to-show - ".$hashref->{'MAX(igra.to_show)'}."
";
# print "time - ".$hashref->{time}."
";
# print "time_now - ".$time_now2."
";
# print ($hashref->{time} cmp $time_now2)."
";
# if(($hashref->{time} cmp $time_now2)>0) { $prognoz=$hashref->{'MAX(igra.to_show)'};
#print "prognoz -".$prognoz."
";
# }
#}
# Если есть что прогнозировать
$query="SELECT * FROM igra, tur WHERE igra.id_tur=tur.id AND tur.id_turnir=$input{id_turnir} AND igra.time>NOW() AND igra.time< date_add(now(), interval 7 day)";
#print $query."
";
$result=$DB->prepare($query) or die "Can't prepare query: $query\n";
$result->execute or die "Can't execute query: $query\n";
!>
Таблица для прогноза -
сейчас -- --
Отображаются матчи, которые начнутся в ближайшие 168 часов