$index = "N"; $pageName = "Current Specials"; $target = ""; $JavaScript = ""; //--[SET LOCAL VARIABLES]--// $today = date("Y-m-d"); $link = @mysql_connect("localhost","ecl_web","web1795"); @mysql_select_db("ecl_econoLodge",$link); $result = @mysql_query(" SELECT title,promotion FROM promotions WHERE active=\"Y\" AND begDate<=\"$today\" AND endDate>=\"$today\" ORDER BY begDate,endDate "); if (@mysql_num_rows($result) == 0) { $link = @mysql_connect("localhost","ecl_web","web1795"); @mysql_select_db("ecl_econoLodge",$link); $result = @mysql_query(" SELECT title,promotion FROM promotions WHERE sequence=\"001\" "); } $row = @mysql_fetch_array($result); $title = $row['title']; $promotion = $row['promotion']; ?> include(''.$_SERVER["DOCUMENT_ROOT"].'/html/head.inc'); ?> include(''.$_SERVER["DOCUMENT_ROOT"].'/html/body.inc'); ?>
|
echo $title; ?> echo $promotion; ?>
|
include(''.$_SERVER["DOCUMENT_ROOT"].'/html/copyright.inc'); ?>