Chyba v php kodu.
Dobrý skoro poledne.
Poraďte mi prosím kde mám chybu?(chyba viz chyba
<?php
$query = "SELECT COUNT(*) FROM sportsdb_teams WHERE teamdiv = {$divs['divid']}";
$result = mysql_query($query);
$result_exist = mysql_result($result,0);
if ($result_exist) {
$query = "SELECT teamid, teamname, nickname, teamwins, teamties, teamlosses, teamforfeits, teamrf, teamra,
(teamwins + teamties + teamlosses + teamforfeits) AS gamesplayed,
(teamwins * $points_win + teamforfeits * $points_forfeit + teamties * $points_tie) AS points,
$winning_pct_formula AS winningpct,
(teamwins - teamlosses - teamforfeits) AS leadervalue
FROM sportsdb_teams
WHERE teamdiv = {$divs['divid']}
ORDER BY leadervalue DESC, teamties DESC LIMIT 1";
$result = mysql_query($query) or die ("Error in query: $query");
$results = mysql_fetch_array($result, MYSQL_ASSOC);
$winningpct = number_format($results['winningpct'], 0);
}
$queryscores="SELECT sportsdb_wins.winid, sportsdb_wins.windate, sportsdb_wins.wintime,
sportsdb_wins.rf, sportsdb_wins.ra, sportsdb_wins.wincomments,
sportsdb_wins.field, sportsdb_wins.winortie,
sportsdb_teams2.teamname AS winningteam,
sportsdb_teams.teamname AS losingteam
FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams
WHERE sportsdb_teams2.teamid = sportsdb_wins.winner
AND sportsdb_teams.teamid = sportsdb_wins.loser
$team_specific_sort
$score_game_filter
ORDER BY wintime $score_sort";
$resultscores=mysql_query($queryscores);
while ($scores = mysql_fetch_array($resultscores, MYSQL_ASSOC)) {
$windateheader=$scores['windate'];
$windateformatted=date("F d, Y",$windateheader);
$wintime=$scores['wintime'];
$hour=date('g',$wintime);
$minute=date('i',$wintime);
$ampm=date('a',$wintime);
?>
Řádek 80= $result_exist = mysql_result($result,0);
Děkuji za radu.
proč tam máš tu nulu? a co je opravdu v proměnné $result?
dle chyby ti chybí parametr 1
a mimochodem, uvádíš sice kód, ale zrovna řádek 80 a kolem něj neuvádíš ;)
Zde je celý soubor pls koukneš na to? Děkuji
By nestačilo?
celý jsem to přepsal a už je to funkční viz. odkaz
Díky za rady.