bravo14 Posted March 28, 2009 Share Posted March 28, 2009 Hi guys I shall try and explain this clearly... I have one table in a database that shows the fixtures, and I have a table showing all of the goalscorers for each fixture linked by a field called fixture_id. What i want to achieve is next to the result show the goalscorers for that game, below is the entire code for the page When I display the page I get all of the fixtures displayed but no goalscorers, now we may not be the best team in the world but we have scored this season I did seek some help from a friend, which resulted in this page... <?php require_once('includes/connect.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $maxRows_rsFixtures = 20; $pageNum_rsFixtures = 0; if (isset($_GET['pageNum_rsFixtures'])) { $pageNum_rsFixtures = $_GET['pageNum_rsFixtures']; } $startRow_rsFixtures = $pageNum_rsFixtures * $maxRows_rsFixtures; ; $query_rsFixtures = "SELECT * FROM tbl_fixtures WHERE tbl_fixtures.team_id = 1"; $query_limit_rsFixtures = sprintf("%s LIMIT %d, %d", $query_rsFixtures, $startRow_rsFixtures, $maxRows_rsFixtures); $rsFixtures = mysql_query($query_limit_rsFixtures) or die(mysql_error()); $row_rsFixtures = mysql_fetch_assoc($rsFixtures); if (isset($_GET['totalRows_rsFixtures'])) { $totalRows_rsFixtures = $_GET['totalRows_rsFixtures']; } else { $all_rsFixtures = mysql_query($query_rsFixtures); $totalRows_rsFixtures = mysql_num_rows($all_rsFixtures); } $totalPages_rsFixtures = ceil($totalRows_rsFixtures/$maxRows_rsFixtures)-1; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>• Yardley Hockey Club •</title> <meta name="keywords" content="yardley, hockey, league, mrha, small heath, co-op" /> <meta name="description" content="The Official Website of Yardley Hockey Club" /> <link href="style/2008.css" rel="stylesheet" type="text/css" /> <link rel="shortcut icon" href="favicon.ico" > </head> <body bgcolor="#FFFFCC"> <div align="center"> <div id="maincontent"> <div id="header"><img src="images/logo.png" /></div> <div id="scrolltext"> <marquee> <?php include('includes/marquee.php'); ?> </marquee> </div> <div id="topnav"> <a href="index.php"><img src="images/menu/home.png" border="0" /></a> <a href="club.php"><img src="images/menu/club.png" border="0" /></a> <a href="main.php?team_id=1"><img src="images/menu/1st_XI.png" border="0" /></a> <a href="main.php?team_id=2"><img src="images/menu/fathoms.png" border="0" /></a> <a href="main.php?team_id=3"><img src="images/menu/badgers.png" border="0" /></a> <a href="main.php?team_id=4"><img src="images/menu/u11.png" border="0" /></a> <a href="news.php"><img src="images/menu/news.png" border="0" /></a> <a href="forum/index.php"><img src="images/menu/forum.png" border="0" /></a> <a href="links.php"><img src="images/menu/links.png" border="0" /></a> </div> <div id="submenu"> <?php $team = ('SELECT * FROM `tbl_team_menu` where `page` <>"main.php" and `team_id`=\'' . $_GET['team_id'] . '\''); $teamresult=mysql_query($team); while($teamrow = mysql_fetch_array($teamresult)) { echo('<a href="'.$teamrow['page'].'?team_id='.$teamrow['team_id'].'"><img src="images/menu/'.$teamrow['button'].'" border="0"></a>'); } ?> </div> <div id="maintext"> <div id="fixtures"><?php include('includes/next_fixtures.php'); ?> </div> <div align="left"> <table width =75%> <b><tr><td>Date</td><td>Home</td><td width="20">Score</td><td>Away</td><td>Result</td><td>Scorers</td><td>Match Report</td></tr></b> <?php $result = mysql_query('SELECT * FROM `tbl_fixture_dates` INNER JOIN `tbl_fixtures` ON `tbl_fixture_dates`.`date_id` = `tbl_fixtures`.`date_id` WHERE `tbl_fixtures`.`team_id` = \'' . $_GET['team_id'] . '\' order by match_date') or die(mysql_error()); if(mysql_num_rows($result) < 1) { echo('<tr><td colspan="6">Sorry, no results were found.</td></tr>'); } else { while($row = mysql_fetch_array($result)) { if ($row[HomeAway]=="Home") { echo "<tr><td>".date("d-M-Y", strtotime($row['match_date']))."</td><td><b>Yardley</b></td>"; echo ('<td align="center">'.$row[yardley_goals].'-'.$row[opposition_goals].'</td><td>'.$row[Opposition].'</td>'); echo ('<td>'.$row[Result].'</td><td>'); if($row_rsFixtures['yardley_goals']>0) { $match_id = $row_rsFixtures['match_id']; echo "Goal Scorers - "; $maxRows_rsScorers = 10; $pageNum_rsScorers = 0; if (isset($_GET['pageNum_rsScorers'])) { $pageNum_rsScorers = $_GET['pageNum_rsScorers']; } $startRow_rsScorers = $pageNum_rsScorers * $maxRows_rsScorers; $query_rsScorers = "SELECT tbl_scorers.scorer, tbl_scorers.goals, tbl_scorers.match_id, tbl_fixtures.match_id FROM tbl_fixtures, tbl_scorers WHERE tbl_fixtures.match_id = $match_id AND tbl_scorers.match_id = $match_id"; $query_limit_rsScorers = sprintf("%s LIMIT %d, %d", $query_rsScorers, $startRow_rsScorers, $maxRows_rsScorers); $rsScorers = mysql_query($query_limit_rsScorers) or die(mysql_error()); $row_rsScorers = mysql_fetch_assoc($rsScorers); if (isset($_GET['totalRows_rsScorers'])) { $totalRows_rsScorers = $_GET['totalRows_rsScorers']; } else { $all_rsScorers = mysql_query($query_rsScorers); $totalRows_rsScorers = mysql_num_rows($all_rsScorers); } $totalPages_rsScorers = ceil($totalRows_rsScorers/$maxRows_rsScorers)-1; do { echo $row_rsScorers['scorer'] ."("; echo $row_rsScorers['goals']; echo ")<br/>"; } while ($row_rsScorers = mysql_fetch_assoc($rsScorers)); } echo "<br/>"; } while ($row_rsFixtures = mysql_fetch_assoc($rsFixtures)); { echo('</td><td><a href="report.php?match_id='.$row[match_id].'">View Report</a></td></tr>'); echo "<tr><td>".date("d-M-Y", strtotime($row['match_date']))."</td><td>".$row[Opposition]."</td>"; echo ('<td align="center">'.$row[opposition_goals].'-'.$row[yardley_goals].'</td><td><b>Yardley</b></td>'); echo ('<td>'.$row[Result].'</td><td>'); if($row_rsFixtures['yardley_goals']>0) { $match_id = $row_rsFixtures['match_id']; echo "Goal Scorers - "; $maxRows_rsScorers = 10; $pageNum_rsScorers = 0; if (isset($_GET['pageNum_rsScorers'])) { $pageNum_rsScorers = $_GET['pageNum_rsScorers']; } $startRow_rsScorers = $pageNum_rsScorers * $maxRows_rsScorers; $query_rsScorers = "SELECT tbl_scorers.scorer, tbl_scorers.goals, tbl_scorers.match_id, tbl_fixtures.match_id FROM tbl_fixtures, tbl_scorers WHERE tbl_fixtures.match_id = $match_id AND tbl_scorers.match_id = $match_id"; $query_limit_rsScorers = sprintf("%s LIMIT %d, %d", $query_rsScorers, $startRow_rsScorers, $maxRows_rsScorers); $rsScorers = mysql_query($query_limit_rsScorers) or die(mysql_error()); $row_rsScorers = mysql_fetch_assoc($rsScorers); if (isset($_GET['totalRows_rsScorers'])) { $totalRows_rsScorers = $_GET['totalRows_rsScorers']; } else { $all_rsScorers = mysql_query($query_rsScorers); $totalRows_rsScorers = mysql_num_rows($all_rsScorers); } $totalPages_rsScorers = ceil($totalRows_rsScorers/$maxRows_rsScorers)-1; do { echo $row_rsScorers['scorer'] ."("; echo $row_rsScorers['goals']; echo ")<br/>"; } while ($row_rsScorers = mysql_fetch_assoc($rsScorers)); } echo "<br/>"; } while ($row_rsFixtures = mysql_fetch_assoc($rsFixtures)); echo('</td><td><a href="report.php?match_id='.$row[match_id].'">View Report<a></td></tr>'); } } mysql_close($con); ?> </table> </div> </div> <div> </div> </div> </body> </html> <?php mysql_free_result($rsFixtures); mysql_free_result($rsScorers); ?> Any ideas, please Quote Link to comment Share on other sites More sharing options...
gnawz Posted March 28, 2009 Share Posted March 28, 2009 echo your fixtures then echo a space then echo your goal scorers You can put this in a 2 column table if you have many results to display Quote Link to comment Share on other sites More sharing options...
bravo14 Posted March 28, 2009 Author Share Posted March 28, 2009 Thanks for your reply, but I want to try and get the goalscorers showing in the format laid out in the page Any help would be appreciated Quote Link to comment Share on other sites More sharing options...
gnawz Posted March 30, 2009 Share Posted March 30, 2009 Try selecting each field as opposed to select *(ALL) ie <? "SELECT table1.field1, table1.field2, table1.field3, table2.field1, table2.field2 FROM table1,table2 WHERE table1.ID1= table2.ID1'; ?> Quote Link to comment Share on other sites More sharing options...
bravo14 Posted April 4, 2009 Author Share Posted April 4, 2009 This is the sample code that I got back from a friend and this works <?php require_once('Connections/conn_mysql.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $maxRows_rsFixtures = 20; $pageNum_rsFixtures = 0; if (isset($_GET['pageNum_rsFixtures'])) { $pageNum_rsFixtures = $_GET['pageNum_rsFixtures']; } $startRow_rsFixtures = $pageNum_rsFixtures * $maxRows_rsFixtures; mysql_select_db($database_conn_mysql, $conn_mysql); $query_rsFixtures = "SELECT * FROM tbl_fixtures WHERE tbl_fixtures.team_id = 1"; $query_limit_rsFixtures = sprintf("%s LIMIT %d, %d", $query_rsFixtures, $startRow_rsFixtures, $maxRows_rsFixtures); $rsFixtures = mysql_query($query_limit_rsFixtures, $conn_mysql) or die(mysql_error()); $row_rsFixtures = mysql_fetch_assoc($rsFixtures); if (isset($_GET['totalRows_rsFixtures'])) { $totalRows_rsFixtures = $_GET['totalRows_rsFixtures']; } else { $all_rsFixtures = mysql_query($query_rsFixtures); $totalRows_rsFixtures = mysql_num_rows($all_rsFixtures); } $totalPages_rsFixtures = ceil($totalRows_rsFixtures/$maxRows_rsFixtures)-1; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <h1>Fixtures</h1> <?php do { echo $row_rsFixtures['Opposition']; echo "("; echo $row_rsFixtures['yardley_goals']; echo ":"; echo $row_rsFixtures['opposition_goals']; echo ")"; echo "<br/>"; if($row_rsFixtures['yardley_goals']>0) { $match_id = $row_rsFixtures['match_id']; echo "Goal Scorers - "; $maxRows_rsScorers = 10; $pageNum_rsScorers = 0; if (isset($_GET['pageNum_rsScorers'])) { $pageNum_rsScorers = $_GET['pageNum_rsScorers']; } $startRow_rsScorers = $pageNum_rsScorers * $maxRows_rsScorers; mysql_select_db($database_conn_mysql, $conn_mysql); $query_rsScorers = "SELECT tbl_scorers.scorer, tbl_scorers.goals, tbl_scorers.match_id, tbl_fixtures.match_id FROM tbl_fixtures, tbl_scorers WHERE tbl_fixtures.match_id = $match_id AND tbl_scorers.match_id = $match_id"; $query_limit_rsScorers = sprintf("%s LIMIT %d, %d", $query_rsScorers, $startRow_rsScorers, $maxRows_rsScorers); $rsScorers = mysql_query($query_limit_rsScorers, $conn_mysql) or die(mysql_error()); $row_rsScorers = mysql_fetch_assoc($rsScorers); if (isset($_GET['totalRows_rsScorers'])) { $totalRows_rsScorers = $_GET['totalRows_rsScorers']; } else { $all_rsScorers = mysql_query($query_rsScorers); $totalRows_rsScorers = mysql_num_rows($all_rsScorers); } $totalPages_rsScorers = ceil($totalRows_rsScorers/$maxRows_rsScorers)-1; do { echo $row_rsScorers['scorer'] ."("; echo $row_rsScorers['goals']; echo ")<br/>"; } while ($row_rsScorers = mysql_fetch_assoc($rsScorers)); } echo "<br/>"; } while ($row_rsFixtures = mysql_fetch_assoc($rsFixtures)); ?> </body> </html> <?php mysql_free_result($rsFixtures); mysql_free_result($rsScorers); ?> however when I copy this code into the page layout I want the goalscorers do not display, the code for that is <?php require_once('includes/connect.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $maxRows_rsFixtures = 20; $pageNum_rsFixtures = 0; if (isset($_GET['pageNum_rsFixtures'])) { $pageNum_rsFixtures = $_GET['pageNum_rsFixtures']; } $startRow_rsFixtures = $pageNum_rsFixtures * $maxRows_rsFixtures; ; $query_rsFixtures = "SELECT * FROM tbl_fixtures WHERE tbl_fixtures.team_id = 1"; $query_limit_rsFixtures = sprintf("%s LIMIT %d, %d", $query_rsFixtures, $startRow_rsFixtures, $maxRows_rsFixtures); $rsFixtures = mysql_query($query_limit_rsFixtures) or die(mysql_error()); $row_rsFixtures = mysql_fetch_assoc($rsFixtures); if (isset($_GET['totalRows_rsFixtures'])) { $totalRows_rsFixtures = $_GET['totalRows_rsFixtures']; } else { $all_rsFixtures = mysql_query($query_rsFixtures); $totalRows_rsFixtures = mysql_num_rows($all_rsFixtures); } $totalPages_rsFixtures = ceil($totalRows_rsFixtures/$maxRows_rsFixtures)-1; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>• Yardley Hockey Club •</title> <meta name="keywords" content="yardley, hockey, league, mrha, small heath, co-op" /> <meta name="description" content="The Official Website of Yardley Hockey Club" /> <link href="style/2008.css" rel="stylesheet" type="text/css" /> <link rel="shortcut icon" href="favicon.ico" > </head> <body bgcolor="#FFFFCC"> <div align="center"> <div id="maincontent"> <div id="header"><img src="images/logo.png" /></div> <div id="scrolltext"> <marquee> <?php include('includes/marquee.php'); ?> </marquee> </div> <div id="topnav"> <a href="index.php"><img src="images/menu/home.png" border="0" /></a> <a href="club.php"><img src="images/menu/club.png" border="0" /></a> <a href="main.php?team_id=1"><img src="images/menu/1st_XI.png" border="0" /></a> <a href="main.php?team_id=2"><img src="images/menu/fathoms.png" border="0" /></a> <a href="main.php?team_id=3"><img src="images/menu/badgers.png" border="0" /></a> <a href="main.php?team_id=4"><img src="images/menu/u11.png" border="0" /></a> <a href="news.php"><img src="images/menu/news.png" border="0" /></a> <a href="forum/index.php"><img src="images/menu/forum.png" border="0" /></a> <a href="links.php"><img src="images/menu/links.png" border="0" /></a> </div> <div id="submenu"> <?php $team = ('SELECT * FROM `tbl_team_menu` where `page` <>"main.php" and `team_id`=\'' . $_GET['team_id'] . '\''); $teamresult=mysql_query($team); while($teamrow = mysql_fetch_array($teamresult)) { echo('<a href="'.$teamrow['page'].'?team_id='.$teamrow['team_id'].'"><img src="images/menu/'.$teamrow['button'].'" border="0"></a>'); } ?> </div> <div id="maintext"> <div id="fixtures"><?php include('includes/next_fixtures.php'); ?> </div> <div align="left"> <table width =75%> <b><tr><td>Date</td><td>Home</td><td width="20">Score</td><td>Away</td><td>Result</td><td>Scorers</td><td>Match Report</td></tr></b> <?php $result = mysql_query('SELECT * FROM `tbl_fixture_dates` INNER JOIN `tbl_fixtures` ON `tbl_fixture_dates`.`date_id` = `tbl_fixtures`.`date_id` WHERE `tbl_fixtures`.`team_id` = \'' . $_GET['team_id'] . '\' order by match_date') or die(mysql_error()); if(mysql_num_rows($result) < 1) { echo('<tr><td colspan="6">Sorry, no results were found.</td></tr>'); } else { while($row = mysql_fetch_array($result)) { if ($row[HomeAway]=="Home") { echo "<tr><td>".date("d-M-Y", strtotime($row['match_date']))."</td><td><b>Yardley</b></td>"; echo ('<td align="center">'.$row[yardley_goals].'-'.$row[opposition_goals].'</td><td>'.$row[Opposition].'</td>'); echo ('<td>'.$row[Result].'</td><td>'); if($row_rsFixtures['yardley_goals']>0) { $match_id = $row_rsFixtures['match_id']; echo "Goal Scorers - "; $maxRows_rsScorers = 10; $pageNum_rsScorers = 0; if (isset($_GET['pageNum_rsScorers'])) { $pageNum_rsScorers = $_GET['pageNum_rsScorers']; } $startRow_rsScorers = $pageNum_rsScorers * $maxRows_rsScorers; $query_rsScorers = "SELECT tbl_scorers.scorer, tbl_scorers.goals, tbl_scorers.match_id, tbl_fixtures.match_id FROM tbl_fixtures, tbl_scorers WHERE tbl_fixtures.match_id = $match_id AND tbl_scorers.match_id = $match_id"; $query_limit_rsScorers = sprintf("%s LIMIT %d, %d", $query_rsScorers, $startRow_rsScorers, $maxRows_rsScorers); $rsScorers = mysql_query($query_limit_rsScorers) or die(mysql_error()); $row_rsScorers = mysql_fetch_assoc($rsScorers); if (isset($_GET['totalRows_rsScorers'])) { $totalRows_rsScorers = $_GET['totalRows_rsScorers']; } else { $all_rsScorers = mysql_query($query_rsScorers); $totalRows_rsScorers = mysql_num_rows($all_rsScorers); } $totalPages_rsScorers = ceil($totalRows_rsScorers/$maxRows_rsScorers)-1; do { echo $row_rsScorers['scorer'] ."("; echo $row_rsScorers['goals']; echo ")<br/>"; } while ($row_rsScorers = mysql_fetch_assoc($rsScorers)); } echo "<br/>"; } while ($row_rsFixtures = mysql_fetch_assoc($rsFixtures)); { echo('</td><td><a href="report.php?match_id='.$row[match_id].'">View Report</a></td></tr>'); echo "<tr><td>".date("d-M-Y", strtotime($row['match_date']))."</td><td>".$row[Opposition]."</td>"; echo ('<td align="center">'.$row[opposition_goals].'-'.$row[yardley_goals].'</td><td><b>Yardley</b></td>'); echo ('<td>'.$row[Result].'</td><td>'); if($row_rsFixtures['yardley_goals']>0) { $match_id = $row_rsFixtures['match_id']; echo "Goal Scorers - "; $maxRows_rsScorers = 10; $pageNum_rsScorers = 0; if (isset($_GET['pageNum_rsScorers'])) { $pageNum_rsScorers = $_GET['pageNum_rsScorers']; } $startRow_rsScorers = $pageNum_rsScorers * $maxRows_rsScorers; $query_rsScorers = "SELECT tbl_scorers.scorer, tbl_scorers.goals, tbl_scorers.match_id, tbl_fixtures.match_id FROM tbl_fixtures, tbl_scorers WHERE tbl_fixtures.match_id = $match_id AND tbl_scorers.match_id = $match_id"; $query_limit_rsScorers = sprintf("%s LIMIT %d, %d", $query_rsScorers, $startRow_rsScorers, $maxRows_rsScorers); $rsScorers = mysql_query($query_limit_rsScorers) or die(mysql_error()); $row_rsScorers = mysql_fetch_assoc($rsScorers); if (isset($_GET['totalRows_rsScorers'])) { $totalRows_rsScorers = $_GET['totalRows_rsScorers']; } else { $all_rsScorers = mysql_query($query_rsScorers); $totalRows_rsScorers = mysql_num_rows($all_rsScorers); } $totalPages_rsScorers = ceil($totalRows_rsScorers/$maxRows_rsScorers)-1; do { echo $row_rsScorers['scorer'] ."("; echo $row_rsScorers['goals']; echo ")<br/>"; } while ($row_rsScorers = mysql_fetch_assoc($rsScorers)); } echo "<br/>"; } while ($row_rsFixtures = mysql_fetch_assoc($rsFixtures)); echo('</td><td><a href="report.php?match_id='.$row[match_id].'">View Report<a></td></tr>'); } } mysql_close($con); ?> </table> </div> </div> <div><div id="footers">designed and hosted by <a href="http://www.bravo14.co.uk" target="_blank">bravo14.co.uk</a></div> <div id="footer">© 2005-<?php echo date("Y") ?> Yardley Hockey Club</div></div> </div> </div> </body> </html> <?php mysql_free_result($rsFixtures); mysql_free_result($rsScorers); ?> Any ideas where I havw gone wrong Cheers Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.