PLAYER INFORMATION

 

 SPONSORS

 

 ABOUT THE MJT

 RANKINGS


"; echo ""; } echo ""; ?>
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>

 » Full Results

 » Top Finishers

 » Callaway OOM

 » Press Release

 » Awards

 » Achievements

 » Draw Prizes

 » Presenting Sponsor

 » Official Sponsors

 » Tournament Sponsors

 » Product Sponsors

 » Membership Information

 » Entry Procedures

 » Application Download

 » Code of Conduct

 » About the WCJGT

 » Qualifying Tournaments

"; echo date("j", $row[0]); echo " - "; echo date("j", $row2[0]); } function insert_tdates($tnumber) { connect_maplejt(); $query = "SELECT UNIX_TIMESTAMP(tournament_date) FROM tournaments WHERE tournament_id = '$tnumber'"; $query2 = "SELECT UNIX_TIMESTAMP(tournament_date2) FROM tournaments WHERE tournament_id = '$tnumber'"; $result = mysql_query ($query); $result2 = mysql_query ($query2); $row = mysql_fetch_array($result); $row2 = mysql_fetch_array($result2); $row[0] = $row[0] + 82800; // adjust to correct date??!! $row2[0] = $row2[0] + 82800; // adjust to correct date??!! echo date("F ", $row[0]); echo date("j", $row[0]); echo " - "; echo date("j", $row2[0]); } function insert_tdatefull($tnumber) { connect_maplejt(); $query = "SELECT UNIX_TIMESTAMP(tournament_date) FROM tournaments WHERE tournament_id = '$tnumber'"; $query2 = "SELECT UNIX_TIMESTAMP(tournament_date2) FROM tournaments WHERE tournament_id = '$tnumber'"; $result = mysql_query ($query); $result2 = mysql_query ($query2); $row = mysql_fetch_array($result); $row2 = mysql_fetch_array($result2); $row[0] = $row[0] + 82800; // adjust to correct date??!! $row2[0] = $row2[0] + 82800; // adjust to correct date??!! echo date("F j", $row[0]); echo " - "; echo date("F j, Y", $row2[0]); } function insert_ndate($nnumber) { connect_maplejt(); $query = "SELECT UNIX_TIMESTAMP(news_date) FROM news WHERE news_id = '$nnumber'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); echo date("F j, Y", $row[0]); } function insert_signup() { ?>
"; echo ""; echo ""; } function insert_microsponsor($sponsor_id, $id){ if (($id == 41) || ($id == 44) || ($id == 45) || ($id == 46) || ($id == 53)) { echo ""; return; } if (($id == 51)) { echo ""; return; } if ($sponsor_id == 0) { ?> "; } } function insert_presentingsponsor() { connect_maplejt(); $query = "SELECT * FROM sponsors WHERE sponsor_id = '1'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); echo ""; echo ""; echo ""; echo ""; echo "

"; echo "

"; echo ""; echo "
"; } function insert_sponsor() { connect_maplejt(); $query = "SELECT sponsor_id FROM sponsors ORDER BY sponsor_id DESC"; $result = mysql_query ($query); $row = mysql_fetch_array($result); $max_sponsor_id = $row[sponsor_id]; $random_sponsor_id = rand(1,$max_sponsor_id); $query = "SELECT * FROM sponsors WHERE sponsor_id = $random_sponsor_id"; $result = mysql_query ($query); $row = mysql_fetch_array($result); echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo "

$row[sponsor_name]

"; echo ""; // determine what page to like the sponsor link to if ($row[sponsor_type] == 'official'){ echo ""; } if ($row[sponsor_type] == 'presenting'){ echo ""; } if ($row[sponsor_type] == 'product'){ echo ""; } if ($row[sponsor_type] == 'tournament'){ echo ""; } echo "
"; $s_text = stripslashes($row[sponsor_text]); $s_text2 = substr($s_text, 0, 300); // truncate string to 300 charicters echo $s_text2; if (strlen($s_text2) > 295) echo "..."; echo "

(Read More)

(Read More)

(Read More)

(Read More)

"; echo "

"; echo ""; // echo ""; echo "
 
"; } function insert_sponsor_name($id) { // get a random sponsor ID connect_maplejt(); $query = "SELECT * FROM sponsors WHERE sponsor_id = '$id'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); echo "$row[sponsor_name]"; if ($row[sponsor_type] == 'official'){ echo "
Read More"; } if ($row[sponsor_type] == 'presenting'){ echo "
Read More"; } if ($row[sponsor_type] == 'product'){ echo "
Read More"; } if ($row[sponsor_type] == 'tournament'){ echo "
Read More"; } } function insert_sponsor_image_by_id($id) { // get a random sponsor ID connect_maplejt(); $query = "SELECT * FROM sponsors WHERE sponsor_id = '$id'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); echo ""; } function insert_sponsor_by_id($id) { if ($id == 0) { return; } // get a random sponsor ID connect_maplejt(); $query = "SELECT * FROM sponsors WHERE sponsor_id = '$id'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo "

$row[sponsor_name]

"; echo ""; // determine what page to like the sponsor link to if ($row[sponsor_type] == 'official'){ echo ""; } if ($row[sponsor_type] == 'presenting'){ echo ""; } if ($row[sponsor_type] == 'product'){ echo ""; } if ($row[sponsor_type] == 'tournament'){ echo ""; } echo "
"; $s_text = stripslashes($row[sponsor_text]); $s_text2 = substr($s_text, 0, 300); // truncate string to 300 charicters echo $s_text2; if (strlen($s_text2) > 295) echo "..."; echo "

(Read More)

(Read More)

(Read More)

(Read More)

"; echo "

"; echo ""; // echo ""; echo "
 
"; } function insert_sponsormenu(){ ?>

Official Sponsors
Tournament Sponsors
Product Sponsors
MJT Affiliated Organizations
Long Drive Competition Sponsor
Skills Competition Sponsor


Just one of the special benefits for MJT members is a complimentary copy of GolfWest magazine!

Featuring MJT player profiles, MJT tournament results and more.

Watch this space for future Member Specials

www.mygolfwest.com
"; echo ""; echo ""; echo ""; } ?>

"; echo stripslashes($row[sponsor_text]); if (!($row[sponsor_website] == NULL)){ echo " - "; echo "$row[sponsor_website]"; } echo ""; echo "

 

THE HONDA WAY JUNIOR
AT LEDGEVIEW GC

Check HERE for Tee Times posted 48 hours prior to tournament

ONTARIO MAJOR JUNIOR CHAMPIONSHIPS ANNOUNCED!

The 2003 season of 24 tournaments now includes two major championships in Ontario under the Nationwide Junior Tour banner in affiliation with the Ontario and Northern Ontario Professional Golfers' Associations.

August 11-12: The Ontario PGA Junior Championship presented by MAZDA at Royal Ashburn GC, Ashburn, ON

August 25-26: The Northern Ontario Junior Championship presented by MAZDA at Timberwolf Golf Club, Sudbury, ON


Click here to register!


Note: Look for the full Ontario schedule for 2004, due this November! More tournaments will be scheduled as the top junior Tour in Canada increases the opportunities for juniors across the country.



"The Ontario PGA is proud to partner with the Western Canada Junior Golf Tour (now Nationwide Junior Golf Tour) on this exciting new venture. Combining our two Associations will surely benefit both parties and provide Ontario's junior golfers with another venue to test their abilities against their peers. The Ontario PGA is committed to excellence in all its undertakings and you and your players should expect nothing less than a great event."......Chris Jones, Captain, Ontario PGA

RESULTS posted within 24 hours of each tournament

"; echo "

Prev "; ?> "; ?> Next  

Previous Event   "; echo "Next Event   "; } function checkposted_topresults($tournament){ connect_maplejt(); $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_place > 0 LIMIT 1"; $result = mysql_query ($query); // insert title $row = mysql_fetch_array($result); if (isset($row[1])) return 1; else return 0; } function checkposted_oomresults($tournament){ connect_maplejt(); $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_oom > 0 LIMIT 1"; $result = mysql_query ($query); // insert title $row = mysql_fetch_array($result); if (isset($row[1])) return 1; else return 0; } function checkposted_pressresults($tournament){ connect_maplejt(); $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); if ($row[result_press] == NULL) { return 0; } else return 1; } function checkposted_awardsresults($tournament){ connect_maplejt(); $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); if ($row[result_awards] == NULL) { return 0; } else return 1; } function checkposted_achresults($tournament){ connect_maplejt(); $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); if ($row[result_ach] == NULL) { return 0; } else return 1; } function checkposted_prizesresults($tournament){ connect_maplejt(); $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); if ($row[result_prizes] == NULL) { return 0; } else return 1; } function checkposted_photoresults($tournament){ return 0; } function checkposted_teetimes($tournament){ connect_maplejt(); $query = "SELECT * FROM teetimes WHERE teetime_t_id = '$tournament' LIMIT 1"; $result = mysql_query ($query); // insert title $row = mysql_fetch_array($result); if (isset($row[1])) return 1; else return 0; } function checkposted_fullresults($tournament) { connect_maplejt(); $query = "SELECT * FROM scores WHERE tournament = '$tournament' AND year = '2004' LIMIT 1"; $result = mysql_query ($query); // insert title $row = mysql_fetch_array($result); if (isset($row[1])) return 1; else return 0; } // dumps html for full oom function results_show_oom($tournament){ } // dumps html for top finishers function results_show_topfinishers($tournament){ connect_maplejt(); $query = "SELECT * FROM tournaments WHERE tournament_id = '$tournament'"; $result = mysql_query ($query); $t_info = mysql_fetch_array($result); echo ""; echo ""; echo ""; $query = "SELECT * FROM scores WHERE tournament = '$tournament' AND age < 14 AND sex = 'M' ORDER BY total ASC, day2 ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; $place = 0; $previous_total = -1; while($place < 3){ $row = mysql_fetch_array($result); if (!($previous_total == $row[total])) { $place = $place + 1; } $row[place] = $place; if (($row[total] == 10000)||($row[total] == 20000)){ $row[place] = ""; // DNF or DQ'd } $previous_total = $row[total]; $row[name] = player_lookup_name($row[player_id]); $row[location] = player_lookup_location($row[player_id]); if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo ""; $query = "SELECT * FROM scores WHERE tournament = '$tournament' AND age > 13 AND age < 17 AND sex = 'M' ORDER BY total ASC, day2 ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; $place = 0; $previous_total = -1; while($place < 3){ $row = mysql_fetch_array($result); if (!($previous_total == $row[total])) { $place = $place + 1; } $row[place] = $place; if (($row[total] == 10000)||($row[total] == 20000)){ $row[place] = ""; // DNF or DQ'd } $previous_total = $row[total]; $row[name] = player_lookup_name($row[player_id]); $row[location] = player_lookup_location($row[player_id]); if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo ""; $query = "SELECT * FROM scores WHERE tournament = '$tournament' AND age > 16 AND sex = 'M' ORDER BY total ASC, day2 ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; $place = 0; $previous_total = -1; while($place < 3){ $row = mysql_fetch_array($result); if (!($previous_total == $row[total])) { $place = $place + 1; } $row[place] = $place; if (($row[total] == 10000)||($row[total] == 20000)){ $row[place] = ""; // DNF or DQ'd } $previous_total = $row[total]; $row[name] = player_lookup_name($row[player_id]); $row[location] = player_lookup_location($row[player_id]); if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo ""; $query = "SELECT * FROM scores WHERE tournament = '$tournament' AND sex = 'F' ORDER BY total ASC, day2 ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; $place = 0; $previous_total = -1; while($place < 3){ $row = mysql_fetch_array($result); if (!($previous_total == $row[total])) { $place = $place + 1; } $row[place] = $place; if (($row[total] == 10000)||($row[total] == 20000)){ $row[place] = ""; // DNF or DQ'd } $previous_total = $row[total]; $row[name] = player_lookup_name($row[player_id]); $row[location] = player_lookup_location($row[player_id]); if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } // insert title echo "

 Top Finishers

  Boys 13 & Under

  "; echo "$row[place]"; echo "

  $row[name]

$row[location]

($row[day1] - $row[day2])

$row[total]

  Boys 14 - 16

  "; echo "$row[place]"; echo "

  $row[name]

$row[location]

($row[day1] - $row[day2])

$row[total]

  Boys 17 & Up

  "; echo "$row[place]"; echo "

  $row[name]

$row[location]

($row[day1] - $row[day2])

$row[total]

  Girls

  "; echo "$row[place]"; echo "

  $row[name]

$row[location]

($row[day1] - $row[day2])

$row[total]

"; } function player_lookup_name($player_id){ $query = "SELECT * FROM teetimes WHERE player_id = '$player_id' LIMIT 1"; $result = mysql_query ($query); $row = mysql_fetch_array($result); return $row[name]; } function player_lookup_location($player_id){ $query = "SELECT * FROM teetimes WHERE player_id = '$player_id' LIMIT 1"; $result = mysql_query ($query); $row = mysql_fetch_array($result); return $row[location]; } // dumps html for top skills comp function results_show_skills($tournament){ $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); echo ""; echo ""; echo ""; echo "

 Skills Competition


$row[skills]

"; } /** // dumps html for top finishers function results_show_pressrelease($tournament){ $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); } function results_show_pressreleasesummary($tournament){ $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); } // dumps html for top finishers function results_show_gallery($tournament){ } //*/ // dumps html for top finishers function results_show_gallerypreview($tournament){ echo ""; echo ""; echo ""; echo "

 Photos


Photos comming
soon!









"; } // dumps html for top finishers function results_show_longdrive($tournament){ $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); echo ""; echo ""; echo ""; echo "

 Skills Competition


$row[awards]

"; } function insert_results_tlist($year) { ?> "; echo ""; while($row = mysql_fetch_array($result)) { if($bgcolor == '#CCCCCC') $bgcolor = '#FFFFFF'; else $bgcolor = '#CCCCCC'; echo ""; echo ""; echo ""; } echo "

Tournament Name

Full

OOM

 $row[tournament_name]

"; echo ""; echo ""; echo ""; echo "
"; } function insert_static($static_id) { connect_maplejt(); $query = "SELECT * FROM staticpages WHERE pagename = '$static_id'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); $row[pagetext] = stripslashes($row[pagetext]); $row[header] = stripslashes($row[header]); if ($static_id == 'tournament_updates') { echo "$row[pagetext]"; return; } ?>

  


"; echo ""; while($row = mysql_fetch_array($result)) { if ($bgcolor == "ECECEC") { $bgcolor = "FFFFFF"; } else{ $bgcolor = "ECECEC"; } echo ""; } echo "

  Date

Sponsor

Name

"; insert_tdate($row[tournament_id]); echo "

"; insert_microsponsor(get_sponsor_id($row[tournament_id]),$row[tournament_id]); echo "

$row[tournament_name]"; if (checkposted_fullresults($row[tournament_id])){ echo "
Full Results"; } else { echo "
no results data available"; } if (checkposted_topresults($row[tournament_id])){ echo "
Top Finishers"; } if (checkposted_oomresults($row[tournament_id])){ echo "
Callaway Golf Order of Merit"; } if (checkposted_pressresults($row[tournament_id])){ echo "
Press Release"; } if (checkposted_awardsresults($row[tournament_id])){ echo "
Awards"; } if (checkposted_achresults($row[tournament_id])){ echo "
Achievements"; } if (checkposted_prizesresults($row[tournament_id])){ echo "
Draw Prizes"; } if (checkposted_photoresults($row[tournament_id])){ echo "
Photo Gallery"; } echo "

"; // end table } function insert_tlist() { connect_maplejt(); $query = "SELECT * FROM tournaments WHERE year = '2004'"; $result = mysql_query ($query); $bgcolor = "ECECEC"; echo ""; echo ""; while($row = mysql_fetch_array($result)) { if ($bgcolor == "ECECEC") { $bgcolor = "FFFFFF"; } else{ $bgcolor = "ECECEC"; } echo ""; } echo "

  Date

Sponsor

Name / Location / Qualifier Information

Fee

"; insert_tdate($row[tournament_id]); echo "

"; insert_microsponsor(get_sponsor_id($row[tournament_id]),$row[tournament_id]); echo "

$row[tournament_name]
$row[tournament_location]"; if (!$row[tournament_name2] == NULL) { echo "
$row[tournament_name2]"; } echo "

$row[tournament_fee]

"; // end table } function insert_schedule() { connect_maplejt(); $query = "SELECT * FROM tournaments WHERE year = '2004'"; $result = mysql_query ($query); $bgcolor = "ECECEC"; echo ""; echo ""; while($row = mysql_fetch_array($result)) { if ($bgcolor == "ECECEC") { $bgcolor = "FFFFFF"; } else{ $bgcolor = "ECECEC"; } echo ""; } echo "

  Date

  Sponsor

Name / Location / Qualifier Information

"; insert_tdate($row[tournament_id]); echo "

$row[tournament_name]
$row[tournament_location]"; if (!$row[tournament_name2] == NULL) { echo "
$row[tournament_name2]"; } echo "

"; // end table } function insert_resultsheader($tournament, $prefix) { connect_maplejt(); // echo $tournament; $query = "SELECT * FROM tournaments WHERE tournament_id = '$tournament'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); echo ""; echo ""; if (!($row[tournament_name2] == NULL)){ echo ""; } echo ""; echo ""; echo ""; echo "

 $prefix $row[tournament_name]

 $row[tournament_name2]

 

 "; insert_tdatefull($row[tournament_id]); echo "

"; if ($prefix == "Callaway Order of Merit points from the") { echo ""; } if (($row[sponsor_id] != 0) && !($prefix == "Callaway Order of Merit points from the")){ insert_sponsor_image_by_id($row[sponsor_id]); } echo "

 $row[course_name], $row[tournament_location]

 
"; } function insert_topresults($tournament) { connect_maplejt(); echo ""; echo ""; echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_place > 0 AND result_place < 4 AND result_age < 14 AND result_sex = 'M' ORDER BY result_place ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_place > 0 AND result_place < 4 AND result_age > 13 AND result_age < 17 AND result_sex = 'M' ORDER BY result_place ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_place > 0 AND result_place < 4 AND result_age > 16 AND result_sex = 'M' ORDER BY result_place ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_place > 0 AND result_place < 4 AND result_sex = 'F' ORDER BY result_place ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } // insert title echo "

  Place

  Name

City

Sex

Age

Scores

Total

  Boys 13 & Under

  $row[result_place]

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_scores]

$row[result_total]

  Boys 14 - 16

  $row[result_place]

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_scores]

$row[result_total]

  Boys 17 & Up

  $row[result_place]

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_scores]

$row[result_total]

  Girls

  $row[result_place]

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_scores]

$row[result_total]

"; } function insert_oomresults($tournament, $year) { connect_maplejt(); echo ""; echo ""; // Boys 13 & Under echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_oom > 0 AND result_age < 14 AND result_sex = 'M' ORDER BY result_oom DESC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } // Boys 14 - 16 echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_oom > 0 AND result_age > 13 AND result_age < 17 AND result_sex = 'M' ORDER BY result_oom DESC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } // Boys 17 and up echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_oom > 0 AND result_age > 16 AND result_sex = 'M' ORDER BY result_oom DESC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } // Girls echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_oom > 0 AND result_sex = 'F' ORDER BY result_oom DESC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo "

  Name

City

Sex

Age

Points

 

  Boys 13 & Under

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_oom]

 

  Boys 14 - 16

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_oom]

 

  Boys 17 & Up

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_oom]

 

  Girls

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_oom]

 

"; } function insert_pressresults($tournament) { connect_maplejt(); $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); // insert title echo ""; echo ""; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo "

  

$row[result_press]

"; } function insert_awardsresults($tournament) { connect_maplejt(); $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); // insert title echo ""; echo ""; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo "

  

$row[result_awards]

"; } function insert_achresults($tournament) { connect_maplejt(); $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); // insert title echo ""; echo ""; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo "

  

$row[result_ach]

"; } function insert_prizesresults($tournament) { connect_maplejt(); $query = "SELECT * FROM textresults WHERE result_t_id = '$tournament'"; $result = mysql_query ($query); // insert title echo ""; echo ""; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo "

  Prizes

$row[result_prizes]

"; } function insert_fullresults($tournament, $year) { connect_maplejt(); $query = "SELECT * FROM tournaments WHERE tournament_id = '$tournament' AND year = '$year'"; $result = mysql_query ($query); $t_info = mysql_fetch_array($result); echo ""; echo ""; echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_age < 14 AND result_sex = 'M' ORDER BY result_place ASC, result_id ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_age > 13 AND result_age < 17 AND result_sex = 'M' ORDER BY result_place ASC, result_id ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_age > 16 AND result_sex = 'M' ORDER BY result_place ASC, result_id ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } echo ""; $query = "SELECT * FROM fullresults WHERE result_t_id = '$tournament' AND result_sex = 'F' ORDER BY result_place ASC, result_id ASC"; $result = mysql_query ($query); $bgcolor = '#EEEEEE'; while($row = mysql_fetch_array($result)){ if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo ""; } // insert title echo "

  Place

  Name

City

Sex

Age

Scores

Total

  Boys 13 & Under - $t_info[B13]

  "; if ($row[result_place] != 10000) { echo "$row[result_place]"; } echo "

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_scores]

$row[result_total]

  Boys 14 - 16 - $t_info[B16]

  "; if ($row[result_place] != 10000) { echo "$row[result_place]"; } echo "

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_scores]

$row[result_total]

  Boys 17 & Up - $t_info[B17]

  "; if ($row[result_place] != 10000) { echo "$row[result_place]"; } echo "

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_scores]

$row[result_total]

  Girls - $t_info[G]

  "; if ($row[result_place] != 10000) { echo "$row[result_place]"; } echo "

  $row[result_name]

$row[result_location]

$row[result_sex]

$row[result_age]

$row[result_scores]

$row[result_total]

"; } function insert_tdata($tcurrent) { connect_maplejt(); $query = "SELECT * FROM tournaments WHERE tournament_id = '$tcurrent'"; $result = mysql_query ($query); $row = mysql_fetch_array($result); $row[tournament_fee] = stripslashes($row[tournament_fee]); $row[tournament_fee_text] = nl2br(stripslashes($row[tournament_fee_text])); $row[tournament_text2] = nl2br(stripslashes($row[tournament_text2])); $row[tournament_qualifiers] = nl2br(stripslashes($row[tournament_qualifiers])); $row[tournament_teetimes] = nl2br(stripslashes($row[tournament_teetimes])); $row[tournament_practice] = nl2br(stripslashes($row[tournament_practice])); $row[tournament_id] = stripslashes($row[tournament_id]); $row[tournament_name] = stripslashes($row[tournament_name]); $row[tournament_name2] = stripslashes($row[tournament_name2]); $row[tournament_name3] = stripslashes($row[tournament_name3]); $row[tournament_location] = stripslashes($row[tournament_location]); $row[tournament_text] = nl2br(stripslashes($row[tournament_text])); $row[course_name] = stripslashes($row[course_name]); $row[course_address] = stripslashes($row[course_address]); $row[course_text] = nl2br(stripslashes($row[course_text])); $row[course_website] = stripslashes($row[course_website]); $row[hotel_text] = nl2br(stripslashes($row[hotel_text])); $row[hotel_phone] = stripslashes($row[hotel_phone]); $row[hotel_website] = stripslashes($row[hotel_website]); $row[hotel_email] = stripslashes($row[hotel_email]); $row[bulletin_text] = stripslashes($row[bulletin_text]); if ($row[tournament_status] == 'OFF') { echo "

Tournament Details for this tournament coming soon!

"; return; } ?> "; } if(!$row[tournament_filename] == NULL){ echo ""; } if (!(checkposted_pressresults($tcurrent))) { // check if press release has been posted.. ?>

  EVENT DETAILS

$row[tournament_name3]

Features
$row[tournament_text]

"; } ?> Rankings / Qualifiers
$row[tournament_qualifiers]

"; } if (!$row[tournament_fee_text] == NULL) { echo "Entry Fee & Registration
$row[tournament_fee_text]

"; } if (!$row[tournament_teetimes] == NULL) { echo "Tee Times
$row[tournament_teetimes]

"; } ?>

Highlights
$row[tournament_text2]

"; } if (!$row[tournament_sponsor] == NULL) { echo "Tournament Sponsor
sponsor text

"; } if (!$row[course_name] == NULL) { echo "Course Details
"; echo "$row[course_name]
"; if (!$row[course_address] == NULL) { echo "$row[course_address]
"; } if (!$row[course_phone] == NULL) { echo "$row[course_phone]
"; } if (!$row[course_text] == NULL) { echo "$row[course_text]
"; } if (!$row[course_email] == NULL) { echo "email: $row[course_email]
"; } if (!$row[course_website] == NULL) { echo "website: $row[course_website]
"; } echo "
"; } if (!($row[sponsor_id] == NULL || $row[sponsor_id] == 0)){ echo "Tournament Sponsor
"; insert_sponsor_name($row[sponsor_id]); echo "

"; } if (!$row[tournament_practice] == NULL){ echo "Practice Rounds
$row[tournament_practice]

"; } if (!$row[hotel_text] == NULL){ echo "Host Hotel
$row[hotel_text]
"; if (!$row[hotel_email] == NULL) { echo "email: $row[hotel_email]
"; } if (!$row[hotel_website] == NULL) { echo "website: $row[hotel_website]
"; } } } else { results_show_pressreleasesummary($tournament); } ?>

"; echo "

  Name

City

Age

Group

"; if ($display_hole == "TRUE") { echo "

Hole

"; } if ($display_teetime == "TRUE") { echo "

Tee Time

"; } echo ""; do { if($bgcolor == '#FFFFFF') $bgcolor = '#EEEEEE'; else $bgcolor = '#FFFFFF'; echo "

  $row[name]

$row[location]

$row[age]

$row[tgroup]

"; if ($display_hole == "TRUE") { echo "

$row[hole]

"; } if ($display_teetime == "TRUE") { echo "

$row[teetime]

"; } echo ""; } while($row = mysql_fetch_array($result)); echo ""; } function insert_teetimeslist() { connect_maplejt(); $query = "SELECT * FROM tournaments WHERE year = '2004'"; $result = mysql_query ($query); $bgcolor = "ECECEC"; echo ""; echo ""; while($row = mysql_fetch_array($result)) { if ($bgcolor == "ECECEC") { $bgcolor = "FFFFFF"; } else{ $bgcolor = "ECECEC"; } echo ""; } echo "

  Date

Sponsor

Name

Status

"; insert_tdate($row[tournament_id]); echo "

"; insert_microsponsor(get_sponsor_id($row[tournament_id]),$row[tournament_id]); echo "

$row[tournament_name]
$row[tournament_location]"; echo "

"; if (checkposted_teetimes($row[tournament_id])) { echo "Posted"; } echo"

"; // end table } function insert_article($article) { connect_maplejt(); $query = "SELECT * from news WHERE news_id = '$article'"; $result = mysql_query ($query); while($row = mysql_fetch_array($result)) { $row[article_name] = stripslashes(strtoupper($row[article_name])); $row[article_text_full] = nl2br(stripslashes($row[article_text_full])); echo ""; echo ""; if(!$row[l_filename] == NULL){ echo ""; } echo ""; echo "

$row[article_name]

$row[article_text_full]

"; } } function insert_news() { connect_maplejt(); $query = "SELECT * from news WHERE article_state = 'ON' ORDER BY news_id DESC"; $result = mysql_query ($query); while($row = mysql_fetch_array($result)) { echo ""; if ($row[t_filename] == NULL) { echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; } else { echo "
"; echo ""; } echo "

"; echo stripslashes(strtoupper($row[article_name])); echo"

"; echo stripslashes($row[article_text]); echo "

"; echo "
"; if(!($row[link1_text]== NULL)){ $row[link1_text] = stripslashes($row[link1_text]); echo "

$row[link1_text]"; } if(!($row[link2_text]== NULL)){ $row[link2_text] = stripslashes($row[link2_text]); echo "$row[link2_text]"; } echo "

"; } } function insert_tnews() { /** $items = 4; connect_maplejt(); $query = "SELECT * from news ORDER BY news_id DESC LIMIT $items"; $result = mysql_query ($query); while($row = mysql_fetch_array($result)) { //*/ echo ""; echo ""; echo ""; echo "
"; insert_static('tournament_updates'); echo "

"; echo "

"; echo "
"; } function get_sponsor_id($tournament) { connect_maplejt(); $query = "SELECT * FROM tournaments WHERE tournament_id = '$tournament'"; $result = mysql_query ($query); $rowabc = mysql_fetch_array($result); if ($rowabc[sponsor_id] == NULL){ return 0; } else { return $rowabc[sponsor_id]; } } function get_sponsor_name($tournament) { $sponsor_id = get_sponsor_id($tournament); echo "$sponsor_id"; if ($sponsor_id == 0) { return "None"; } connect_maplejt(); $query = "SELECT * FROM sponsors WHERE sponsor_id = $sponsor_id"; $result = mysql_query ($query); $rowabc = mysql_fetch_array($result); echo $rowabc[sponsor_name]; return $rowabc[sponsor_name]; //return $rowabc[sponsor_id]; } // insert footer function insert_footer() { ?>

 www.maplejt.com

 jrtour@maplejt.com

1-877-859-GOLF 


all images and text © MJT 2004 or their respective owners