omvendt rækkefølge
kig her http://4boys.4b.funpic.org/fodbold/stilling/match.phpsom du kan se bliver de ældste kampe vist først..
er der ik en der vil gøre så de nyeste kampe bliver vist først og de ældste til sidst..?
er er koden til siden
<?
session_start();
include('admin/user.php');
$connection = mysql_connect("$host","$user","$password")
or die(mysql_error());
mysql_select_db("$txt_db_name",$connection)
or die(mysql_error());
//
//Includes preferences
//
$pref = mysql_query("SELECT * FROM tplls_preferences WHERE ID = '1'",$connection)
or die(mysql_error());
$pdata = mysql_fetch_array($pref);
mysql_free_result($pref);
$team_name = $pdata['teamname'];
$d_seasonid = $pdata['defaultseasonid'];
$show_all_or_one = $pdata['defaultshow'];
$show_table = $pdata['defaulttable'];
$language = $pdata['defaultlanguage'];
$for_win = $pdata['forwin'];
$for_draw = $pdata['fordraw'];
$for_lose = $pdata['forloss'];
$print_date = $pdata['printdate'];
$top_bg = $pdata['topoftable'];
$bg1 = $pdata['bg1'];
$bg2 = $pdata['bg2'];
$inside_c = $pdata['inside'];
$border_c = $pdata['bordercolour'];
$tb_width = $pdata['tablewidth'];
$accept_ml = $pdata['acceptmultilanguage'];
//
//Query to get last updated date and time
//
//Use site http://www.mysql.com/doc/en/Date_and_time_functions.html (DATE_FORMAT)
//to return date format that fits to your site
//
$updated_query = mysql_query("
SELECT DATE_FORMAT(last_updated, '%d.%m.%Y at %H:%i') AS last_updated FROM tplls_preferences WHERE ID = '1'", $connection)
or die(mysql_error());
$ludata = mysql_fetch_array($updated_query);
$last_update = $ludata['last_updated'];
mysql_free_result($updated_query);
//
//If session variables are registered
//
if(!session_is_registered('defaultlanguage') || !session_is_registered('defaultseasonid') || !session_is_registered('defaultshow') || !session_is_registered('defaulttable'))
{
$_SESSION['defaultlanguage'] = $language;
$_SESSION['defaultseasonid'] = $d_seasonid;
$_SESSION['defaultshow'] = $show_all_or_one;
$_SESSION['defaulttable'] = $show_table;
$defaultlanguage = $_SESSION['defaultlanguage'];
$defaultseasonid = $_SESSION['defaultseasonid'];
$defaultshow = $_SESSION['defaultshow'];
$defaulttable = $_SESSION['defaulttable'];
}
else
{
$defaultlanguage = $_SESSION['defaultlanguage'];
$defaultseasonid = $_SESSION['defaultseasonid'];
$defaultshow = $_SESSION['defaultshow'];
$defaulttable = $_SESSION['defaulttable'];
}
//
//Includes languages
//
include('language.inc');
?>
<?php
//
//Check if match calendar want to be shown
//
print "<head>
<style type=\"text/css\">
<!--
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 11px;
}
-->
</style>
</head><body>";
if($defaultshow != 3)
{
?>
<table align="left" width="60%" cellspacing="2" cellpadding="2" border="0">
<tr>
<td align="left" valign="top" colspan="2">
<h1><?= $lng_match_calendar ?></h1>
</td>
</tr>
<?php
//
//How to print date
//
if($print_date == 1)
{
$print_date = '%d.%m.%Y';
}
elseif($print_date == 2)
{
$print_date = '%m.%d.%Y';
}
elseif($print_date == 3)
{
$print_date = '%b %D %Y';
}
//
//Check which matche want to be printed
//
//All
//
if($defaultshow == 1)
{
$get_matches = mysql_query("
SELECT O.OpponentName AS hometeam,
OP.OpponentName AS awayteam,
LM.LeagueMatchHomeGoals AS goals_home,
LM.LeagueMatchAwayGoals AS goals_away,
LM.LeagueMatchID AS id,
DATE_FORMAT(LM.LeagueMatchDate, '$print_date') AS date
FROM tplls_leaguematches LM, tplls_opponents O, tplls_opponents OP
WHERE O.OpponentID = LM.LeagueMatchHomeID AND
OP.OpponentID = LM.LeagueMatchAwayID AND
LeagueMatchSeasonID LIKE '$defaultseasonid'
ORDER BY LM.LeagueMatchDate",$connection)
or die(mysql_error());
}
//
//Own only
//
else
{
$get_matches = mysql_query("
SELECT O.OpponentName AS hometeam,
OP.OpponentName AS awayteam,
LM.LeagueMatchHomeGoals AS goals_home,
LM.LeagueMatchAwayGoals AS goals_away,
LM.LeagueMatchID AS id,
DATE_FORMAT(LM.LeagueMatchDate, '$print_date') AS date
FROM tplls_leaguematches LM, tplls_opponents O, tplls_opponents OP
WHERE O.OpponentID = LM.LeagueMatchHomeID AND
OP.OpponentID = LM.LeagueMatchAwayID AND
LeagueMatchSeasonID LIKE '$defaultseasonid' AND
(O.OpponentOwn = '1' OR OP.OpponentOwn = '1')
ORDER BY LM.LeagueMatchDate",$connection)
or die(mysql_error());
}
if(mysql_num_rows($get_matches) < 1)
{
echo "<b>No matches yet.</b>";
}
else
{
$i = 0;
$temp = '';
while($data = mysql_fetch_array($get_matches))
{
if($i == 0)
{
echo"
<tr>
<td align=\"left\" colspan=\"2\">
<b>$data[date]</b>
</td>
</tr>
";
}
if($data['date'] != "$temp" && $i > 0)
{
echo"
<tr>
<td align=\"left\" colspan=\"2\">
<br>
<b>$data[date]</b>
</td>
</tr>
";
}
echo "
<tr>
<td align=\"left\" valign=\"top\" width=\"90%\">
$data[hometeam] - $data[awayteam]
</td>
<td align=\"left\" valign=\"top\" width=\"10%\">";
if(!is_null($data['goals_home']))
echo"$data[goals_home]-$data[goals_away]";
else
echo' ';
echo"
</td>
</tr>";
$temp = "$data[date]";
$i++;
}
}
mysql_free_result($get_matches);
?>
<?php
}
?>
<td></td>
</table>
<br>
