";
require_once("../../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 "
";
}
$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 "