|
$query = "SELECT * FROM `BF_ClubNight`";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$id = $row['ClubNightID'];
$title = strtoupper(stripslashes($row['Title']));
$venue = stripslashes($row['Venue']);
$when = stripslashes($row['When']);
$price = $row['Price'];
?>
|
print($venue); ?>, print($when); ?>
Adm. print($price); ?> |
} ?>
| |
|
//current poster
$today = date("Y-m-d");
$posterQuery = "SELECT * FROM `BF_Image` WHERE `Table` = 'BF_ClubNight' AND `ExpiryDate` >= '$today' ORDER BY `ExpiryDate` ASC";
$posterResult = mysql_query($posterQuery);
if(mysql_num_rows($posterResult) > 0)
{
$posterRow = mysql_fetch_array($posterResult);
$posterSrc = $posterRow['MainLink'];
print("  ");
}
?>
|