PHP Help :(

[Ragnarak]

Ok, what i'm basically trying to do is make a premiership league table that updates when you put the results in.

I've got the inputting results into the database bit done fine, and i can display the results as HTML but what i need to do is say if scorea > scoreb give teama 3 points, etc and not sure how i go about doing this...

Any suggestions or advice?

[Dave]

Assuming that your using MySQL, and that I understand you...

$teamascore = 2;
$teambscore = 4;

if($teamascore > $teambscore) {
    mysql_query("UPDATE league SET points=points+3 WHERE team='$teamaid'");
} elseif($teambscore > $teamascore) {
    mysql_query("UPDATE league SET points=points+3 WHERE team='$teambid'");
} else { //Draw
   mysql_query("UPDATE league SET points=points+1 WHERE teamid='$teamaid' OR teamid='$teambid'");
}

Something along those lines.

(Yes its bad code, but who cares)

[Ragnarak]

cheers, that looks like it'll be useful

[mbushell]

$a['points'] = 0;
$a['score'] = 2;  
$b['points'] = 0;   
$b['score'] = 4;  

if ($a['score'] > $b['score']) {
    // team `a` wins
    $a['points'] += 3;
    // mysql crap
} elseif ($a['score'] < $b['score']) {
    // team `b` wins
    $b['points'] += 3;
    // mysql crap
} else {
    // it's a draw baby yeh
    $a['points']++;
    $b['points']++;
    // mysql crap
}

[Structural Integrity]

I'd go for something more error-secure.
If you now make a typo in the scores you can't turn it back.

I'd store each game outcome and then for a request count the won games and draws, and calculate the scores accordingly.