"; require_once("../../../race/mysql_connection.php"); require_once("../show_link.php"); $sql_tt = "select A.*, J.cname as jcname, J.ename as jename, J.jcd FROM trotting A left join horse_profile H on H.brand_no = A.brand_no left join jockey J on J.jcd = A.jcd where A.trot_date = '$selectday' and A.brand_no = '$brandno'"; if ( ($result_rc = mysql_db_query($dbName, $sql_tt,$link_message)) && ($rc = mysql_fetch_object($result_rc)) ) { echo ""; $jcd = $rc->jcd; if ($jcd == "") { $jcname = $rc->cjockey_name; $jename = $rc->ejockey_name; } else { $jcname = $rc->jcname; $jename = $rc->jename; } $jlink = jockey_link($jcd, $jcname, $jename); echo ""; } $sql_tw = "select A.*, H.cname, H.ename, H1.cname as ch1, H1.ename as en1, H2.cname as ch2, H2.ename as en2, J.cname as jcname, J.ename as jename, J.jcd FROM trackwork A Left Join horse_profile H on H.brand_no = A.brand_no Left Join horse_profile H1 on H1.brand_no = A.with_brand_no1 Left Join horse_profile H2 on H2.brand_no = A.with_brand_no2 left join jockey J on J.jcd = A.jcd where A.track_date = '$selectday' and A.brand_no = '$brandno'"; //echo ""; if ( ($result_rc = mysql_query($sql_tw,$link_message)) && ($rc = mysql_fetch_object($result_rc)) ) { echo ""; $jcd = $rc->jcd; if ($jcd == "") { $jcname = $rc->cjockey_name; $jename = $rc->ejockey_name; } else { $jcname = $rc->jcname; $jename = $rc->jename; } $jlink = jockey_link($jcd, $jcname, $jename); echo ""; echo ""; echo ""; $Gallop = ""; $with_horse = $rc->with_brand_no1; if ($with_horse != "") { $cname = $rc->ch1; if ($cname == "") { $cname = $with_horse; $ename = "未命名 Un-named"; } else { $ename = $rc->en1; } $hlink = horse_link($with_horse,$cname,$ename); $Gallop.= " ".$hlink; } $with_horse = $rc->with_brand_no2; if ($with_horse != "") { $cname = $rc->ch2; if ($cname == "") { $cname = $with_horse; $ename = "未命名 Un-named"; } else { $ename = $rc->en2; } $hlink = horse_link($with_horse,$cname,$ename); $sImgFN = "$imgP/s/$with_horse.JPG"; if (file_exists($sImgFN)) { $bImgFN = "$imgP/b/$with_horse.JPG"; $imgA = ""; } else { $imgA = ""; } if (isset($videoArr[$with_horse])) { $videoA = ""; } else { $videoA = ""; } $Gallop.= " ".$hlink; } if ($Gallop != "") { echo ""; } } ?>

$selectday
Trotting
Jockey	$jlink
Trackwork
Jockey	$jlink
Sectional Time	"; if($rc->time1 != "0") { echo "{$rc->time1} "; } if($rc->time2 != "0") { echo "{$rc->time2} "; } if($rc->time3 != "0") { echo "{$rc->time3}"; } echo "
Race Time	{$rc->total_time}
Gallop	$Gallop