Forum Moderators: not2easy
<?php ini_set('arg_separator.output','&');
include 'includes/open_db.php';
$BeginDate = '2010-07-01';
$EndDate = '2015-04-01';
$recentresults = "SELECT Results.Date, date_format(Date,'%e/%c/%Y') as dates, Venue.gamenight1, Player.FirstName, Player.lastname, Venue.VenueName, Venue.VenueID
FROM Results, Player, Venue
WHERE position =1
AND Results.MembershipNo = Player.MembershipNo
AND Venue.VenueID = Results.VenueID
AND Results.Date
BETWEEN '$BeginDate' AND '$EndDate'
ORDER BY date DESC
LIMIT 0 , 5";
$result1 = mysql_query($recentresults) or die("Couldn't execute query because: ".mysql_error());
$pos=1;
while($r = mysql_fetch_array($result1)){
//and echo each new row
echo <<<html
<li><a href="venueResult.php?Date={$r['Date']}& VenueID={$r['VenueID']}">{$r['FirstName']} {$r['lastname']} won at {$r['VenueName']} on {$r['dates']}</a></li>
html;
$pos++;}
?> <div id="recent_results">
<ul><?php include 'includes/recentresults.php'; ?>
</ul>
</div> #recent_results {
background: url("../images/black/images/recent_results.gif") no-repeat scroll 0 0 transparent;
font-size: 11px;
font-weight: bold;
height: 220px;
padding: 15px 0 0 0;
text-align: center;
width: 221px;
}
#recent_results ul {
height: 13px;
list-style: none outside none;
padding: 14px 0 0 9px;
}
#recent_results ul li {
background: url("../images/black/images/recent_results_box.gif") no-repeat scroll 0 0 transparent;
height: 30px;
padding: 5px 0 3px 20px;
width: 165px;
}
#recent_results ul li a {
color: #FFFFFF;
font-family: arial;
line-height: 11px;
padding: 0 10px 0 0;
text-decoration: none;
} [edited by: alt131 at 7:35 pm (utc) on Sep 14, 2011]
[edit reason] Thread Tidy [/edit]
For some reason in the different browsers it displays line spacing differently and therefore goes beyond the background image I'm trying to keep it in.