As a complete newbie, I'm not sure Ive got the terminology right in my subject header. But this is what I am trying to do.
I have a soccer stats site with data entered into each of numerous 'seasons', accessible via a drop-down menu, as here:
http://www.fleethistory.co.uk/stats/matches.php
Now regardless of what season I select, the URL will stay the same as above. What I want to do is have users go direct to a particular season from a link without having to use the drop-down. How would I generate a unique URL for each of the seasons listed in the drop-down?
Don't know if you need the PHP code, but here it is just in case:
<?php
/*
***************************************************************************
* tplSoccerStats
* -----------------------------------------------------------------------
* Copyright: TPL Design
* email: info@tpl-design.com
* www: www.tpl-design.com/tplsoccerstats
***************************************************************************
*/
// Starts a new session or resumes the current one.
session_start();
// Get db host, db username, db password, and db name from admin/user.php
// (each team has its own db).
include('admin/user.php');
// Establish db connection. Select appropriate team db.
$connection = mysql_connect("$host", "$user", "$password") or die(mysql_error());
mysql_select_db("$txt_db_name", $connection) or die(mysql_error());
// Get preferences stored in db.
$sql = "SELECT * FROM tplss_preferences WHERE ID = '0'";
$pref = mysql_query($sql, $connection) or die(mysql_error());
$pdata = mysql_fetch_array($pref);
mysql_free_result($pref);
// Include php preferences.
include('preferences.inc');
// Use session defaults if available, otherwise set them from database values.
if ((!isSet($_SESSION['defaultseasonid_tplss'])) ||
(!isSet($_SESSION['defaultmatchtypeid_tplss'])) ||
(!isSet($_SESSION['defaultlanguage_tplss']))) {
$_SESSION['defaultseasonid_tplss'] = $pdata['DefaultSeasonID'];
$_SESSION['defaultmatchtypeid_tplss'] = $pdata['DefaultMatchTypeID'];
$_SESSION['defaultlanguage_tplss'] = $pdata['DefaultLanguage'];
}
$defaultseasonid = $_SESSION['defaultseasonid_tplss'];
$defaultmatchtypeid = $_SESSION['defaultmatchtypeid_tplss'];
$defaultlanguage = $_SESSION['defaultlanguage_tplss'];
// Include language based global vars, in our case english, e.g. $txt_preview = 'Preview'
include('language.inc');
// Include pafc banner and menu bar.
include('header.php');
// Start an html form.
echo '<form method="post" action="change.php">' . "\n";
// Print images at top of form if we have them (we don't).
$image_url = "images/header.jpg";
$image_url2 = "images/header.gif";
if(file_exists($image_url) || file_exists($image_url2))
{
echo '<table align="center" width="' . $tb_width . '" cellspacing="0" cellpadding="0" border="0">' . "\n";
echo "<tr>\n";
echo '<td align="center">' . "\n";
if (file_exists($image_url)) {
echo '<img src="' . $image_url . '" ALT=""><br>' . "\n";
}
elseif (file_exists($image_url2)) {
echo '<img src="' . $image_url2 . '" ALT="">' . "\n";
}
echo "</td></tr></table>\n\n";
}
?>
<!-- Print change bar table -->
<table align="center" width="<?php echo $tb_width ?>" cellspacing="0" cellpadding="0" border="0" bgcolor="<?php echo $border_c ?>">
<tr>
<td>
<table width="100%" cellspacing="1" cellpadding="5" border="0">
<tr>
<td bgcolor="<?php echo $inside_c ?>" align="center">
<?= $txt_change ?>:
<select name="season">
<option value="0"><?= $txt_all ?></option>
<?php
$sql = "SELECT * FROM tplss_seasonnames WHERE SeasonPublish = '1' ORDER BY SeasonName DESC";
$get_seasons = mysql_query($sql, $connection) or die(mysql_error());
while($data = mysql_fetch_array($get_seasons))
{
if($data['SeasonID'] == $defaultseasonid)
echo '<option value="' . $data['SeasonID'] . '" SELECTED>' . $data['SeasonName'] . "</option>\n";
else
echo '<option value="' . $data['SeasonID'] . '">' . $data['SeasonName'] . "</option>\n";
}
mysql_free_result($get_seasons);
?>
</select> or Competition:
<select name="matchtype">
<option value="0"><?= $txt_all ?></option>
<?php
$sql = "SELECT * FROM tplss_matchtypes ORDER BY MatchTypeName";
$get_types = mysql_query($sql, $connection) or die(mysql_error());
while($data = mysql_fetch_array($get_types))
{
if($data['MatchTypeID'] == $defaultmatchtypeid)
echo '<option value="' . $data['MatchTypeID'] . '" SELECTED>' . $data['MatchTypeName'] . "</option>\n";
else
echo '<option value="' . $data['MatchTypeID'] . '">' . $data['MatchTypeName'] . "</option>\n";
}
mysql_free_result($get_types);
?>
</select> <input type="submit" name="submit" value="Select">
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- Print outer fixture tables -->
<table align="center" width="<?php echo $tb_width ?>" cellspacing="0" cellpadding="0" border="0" bgcolor="<?php echo $border_c ?>">
<tr>
<td>
<table width="100%" cellspacing="1" cellpadding="5" border="0">
<tr>
<td bgcolor="<?php echo $inside_c ?>" align="center">
<!-- Print inner fixture table -->
<table width="<?= $tb2_width ?>%" cellspacing="0" cellpadding="4" border="0">
<tr>
<td align="left" valign="middle" bgcolor="#D01818">
<font color="#FFffff"><b>Date</b></font>
</td>
<td align="center" valign="middle" bgcolor="#D01818">
<font color="#FFffff"><b>H/A</b></font>
</td>
<td align="left" valign="middle" bgcolor="#D01818">
<font color="#FFffff"><b>Opponent</b></font>
</td>
<td align="left" valign="middle" bgcolor="#D01818">
<font color="#FFffff"><b>Competition</b></font>
</td>
<td align="center" valign="middle" bgcolor="#D01818" colspan="2">
<font color="#FFffff"><b>Result</b></font>
</td>
<td align="center" valign="middle" bgcolor="#D01818">
<font color="#FFffff"><b>Att</b></font>
</td>
<td align="center" valign="middle" bgcolor="#D01818">
<font color="#FFffff"><b>Details</b></font>
</td>
</tr>
<?php
// Construct db query to get fixtures from database.
$selectClause = "SELECT
M.MatchID AS id,
M.MatchAdditionalType AS additype,
O.OpponentName AS opponent,
O.OpponentID AS oppid,
M.MatchGoals AS goals,
M.MatchGoalsOpponent AS goals_opponent,
M.MatchPenaltyGoals AS penalty_goals,
M.MatchPenaltyGoalsOpponent AS penalty_goals_opponent,
M.MatchOvertime AS overtime,
M.MatchPenaltyShootout AS penalty_shootout,
DATE_FORMAT(M.MatchDateTime, '%M %Y') AS month,
DATE_FORMAT(M.MatchDateTime, '%a %e') AS date,
DATE_FORMAT(M.MatchDateTime, '%H:%i') AS time,
M.MatchPlaceID AS place,
M.MatchAttendance AS att,
M.MatchPublish AS publish,
MT.MatchTypeName AS typename,
P.PreviewText AS prewtext
FROM ( tplss_matches M, tplss_matchtypes MT, tplss_opponents O )
LEFT OUTER JOIN tplss_previews P ON M.MatchID = P.PreviewMatchID ";
if (($defaultseasonid != 00) && ($defaultmatchtypeid != 0)) {
$whereClause = "WHERE M.MatchTypeID = '$defaultmatchtypeid'
AND M.MatchSeasonID = '$defaultseasonid'
AND M.MatchTypeID = MT.MatchTypeID
AND M.MatchOpponent = O.OpponentID ";
} elseif (($defaultseasonid == 0) && ($defaultmatchtypeid != 0)) {
$whereClause = "WHERE M.MatchTypeID = '$defaultmatchtypeid'
AND M.MatchTypeID = MT.MatchTypeID
AND M.MatchOpponent = O.OpponentID ";
} elseif (($defaultseasonid != 0) && ($defaultmatchtypeid == 0)) {
$whereClause = "WHERE M.MatchSeasonID = '$defaultseasonid'
AND M.MatchTypeID = MT.MatchTypeID
AND M.MatchOpponent = O.OpponentID ";
} elseif (($defaultseasonid == 0) && ($defaultmatchtypeid == 0)) {
$whereClause = "WHERE M.MatchTypeID = MT.MatchTypeID
AND M.MatchOpponent = O.OpponentID ";
}
$orderByClause = "ORDER BY M.MatchDateTime";
// Execute query.
$sql = $selectClause . $whereClause . $orderByClause;
$get_matches = mysql_query($sql, $connection) or die(mysql_error());
// Loop round fixtures (which come back from database in date order).
while($data = mysql_fetch_array($get_matches))
{
// Print a month header row each time we hit a new month.
if ($data['month'] <> $lastMonth) {
echo "<tr>\n";
echo '<td align="left" valign="middle" bgcolor="#7c0606" colspan="9">';
echo '<font color="#FFffff"><b>' . $data['month'] . "</b></font>";
echo "</td>\n";
echo "</tr>\n\n";
$lastMonth = $data['month'];
}
// Assign home/away based vars.
if ($data['place'] == 1) {
$placeBg = $bg4;
$venue = "H";
} else {
$placeBg = $bg3;
$venue = "A";
}
// Print date and venue.
echo"<tr>\n";
echo '<td align="left" valign="middle" bgcolor="' . $placeBg . '">';
echo $data['date'];
echo "</td>\n";
echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">';
echo $venue;
echo "</td>\n";
// Print opponent team name (as a link if possible).
echo '<td align="left" valign="middle" bgcolor="' . $placeBg . '">';
if ($data['oppid'] == 1) {
echo '$data[opponent]';
} else {
echo '<a href="opponent.php?opp=' . $data['oppid'] . '">' . $data['opponent'] . "</a>";
}
echo "</td>\n";
// Print competition type.
echo '<td align="left" valign="middle" bgcolor="' . $placeBg . '">';
echo $data['typename'];
if ($data['additype'] != '') {
echo " / " . $data['additype'];
}
echo "</td>\n";
// Print result, attendance and match report.
if ($data['goals'] == NULL || $data['goals_opponent'] == NULL) {
// No goals recorded - match can't have been played yet - print empty fields.
echo '<td bgcolor="' . $placeBg . '"> </td>' . "\n";
echo '<td bgcolor="' . $placeBg . '"> </td>' . "\n";
echo '<td bgcolor="' . $placeBg . '"> </td>' . "\n";
echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">';
if ($data['prewtext'] == '') {
echo " ";
} else {
echo '<a href="preview.php?id=' . $data['id'] . '">' . $txt_preview . "</a>";
}
echo "</td>\n";
} else {
// Goals recorded - figure out result and score - print required fields.
if ($data['penalty_goals'] == NULL || $data['penalty_goals_opponent'] == NULL) {
if ($data['goals'] > $data['goals_opponent'])
$result = '<img src="images/win.jpg">';
elseif ($data['goals'] < $data['goals_opponent'])
$result = '<img src="images/lose.jpg">';
else
$result = '<img src="images/draw.jpg">';
$score = $data['goals'] . " - " . $data['goals_opponent'];
} else {
if ($data['penalty_goals'] > $data['penalty_goals_opponent'])
$result = "<b>W</b>";
else
$result = "L";
$score = $data['goals'] . " - " . $data['goals_opponent'] . " (" . $data['penalty_goals'] . " - " . $data['penalty_goals_opponent'] . ")";
}
echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">' . $result . "</td>\n";
echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">' . $score . "</td>\n";
echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">' . $data['att'] . "</td>\n";
if($data['publish'] == 1)
{
echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '"><a href="matchdetails.php?id=' . $data['id'] . '">Yes</td></a></td>' . "\n";
}
else
{
echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '"> </td></a></td>' . "\n";
}
}
echo "</tr>\n\n";
}
// Free resultset.
mysql_free_result($get_matches);
?>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<?php
// Print tpl soccers stats message.
include('bottom.txt');
?>
</form>
<?php
// Finish off html.
include('footer.php');
?>
