include "includes/connect.inc.txt"; function main() { Global $player , $cid; if (!isset($cid)) { $cid=1; } $title="Yorkshire snooker players profiles"; $bodytag = "
\n "; include "oldsite_header.inc"; ?>
| Player Name | Matches Played | Total Score | Total Score Against | Points | In a match?";
Echo "| " . $playername . " | " . $matchesplayed . " | " . $total_score . " | " . $total_score_against . " | " . $points . " | " . $inmatch . " | ";
if ($picture<>"") { echo " | mike@joejohnson.co.uk"; } Echo " Avarage score per game= ";
if ($matchesplayed > 0) { echo " " . round($total_score/$matchesplayed) . " | Average Score Against = " . round($total_score_against/$matchesplayed); } Else Echo " No Matches played so I cannot calculate"; Echo " " . $comments . " "; if ($break>0) { echo "Highest Break " . $break . " "; } Else { Echo "We don't know this players highest break If this is your page please email us your highest break "; } // current working on get dob and work out age getage($dob); } Echo " "; /* list of players played so far $result = mysql_query("select winner_name , loser_name , winner_score , loser_score from matches WHERE winner_name='$playername'"); while(list($winner_name , $loser_name , $winner_score , $loser_score)= mysql_fetch_row($result)) { echo " Won against " . $loser_name . " " . $winner_score . " points to " . $loser_score . " | Lost against " . $winner_name . " " . $winner_score . " points to " . $loser_score . " | |