|
|
|
|
//get all the posters with expiry date after today
$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(" ");
}
?> |
|
FUTURE POSTERS
|
//get all the posters with expiry date after today
$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);
while($posterRow = mysql_fetch_array($posterResult))
{
$posterSrc = $posterRow['ThumbLink'];
$posterMainSrc = $posterRow['MainLink'];
print(" ");
}
?> |
|