0 and id<9 ORDER BY id ASC";
$result_main_all = mysql_query($query_main_all);
while($mainRowAll = mysql_fetch_assoc ($result_main_all)) {
switch ($mainRowAll["id"]) {
case 1:
// Featured Events
$strMainActive_featured = $mainRowAll["active"];
$strMainAnchor_featured = $mainRowAll["displayanchor"];
$strMainTitle_featured = str_replace("\r\n", "
", $mainRowAll["displaytitle"]);
$strMainBody_featured = preg_replace('/
/', '', $mainRowAll["displaybody"], 1);
$strMainBody_featured = preg_replace('/<\/p>/', '', $strMainBody_featured, 1);
break;
case 2:
// More News
$strMainActive_news = $mainRowAll["active"];
$strMainAnchor_news = $mainRowAll["displayanchor"];
$strMainTitle_news = str_replace("\r\n", "
", $mainRowAll["displaytitle"]);
$strMainBody_news = preg_replace('/
/', '', $mainRowAll["displaybody"], 1);
$strMainBody_news = preg_replace('/<\/p>/', '', $strMainBody_news, 1);
break;
case 3:
// Discover Hannaford
$strMainActive_discover = $mainRowAll["active"];
$strMainAnchor_discover = $mainRowAll["displayanchor"];
$strMainTitle_discover = str_replace("\r\n", "
", $mainRowAll["displaytitle"]);
$strMainBody_discover = preg_replace('/
/', '', $mainRowAll["displaybody"], 1);
$strMainBody_discover = preg_replace('/<\/p>/', '', $$strMainBody_discover, 1);
break;
case 4:
// Side Bar
$strMainActive_side = $mainRowAll["active"];
$strMainAnchor_side = $mainRowAll["displayanchor"];
$strMainTitle_side = str_replace("\r\n", "
", $mainRowAll["displaytitle"]);
$strMainBody_side = preg_replace('/
/', '', $mainRowAll["displaybody"], 1);
$strMainBody_side = preg_replace('/<\/p>/', '', $strMainBody_side, 1);
break;
case 5:
// Compassion in Action
$strMainActive_compassion = $mainRowAll["active"];
$strMainAnchor_compassion = $mainRowAll["displayanchor"];
$strMainTitle_compassion = str_replace("\r\n", "
", $mainRowAll["displaytitle"]);
$strMainBody_compassion = preg_replace('/
/', '', $mainRowAll["displaybody"], 1);
$strMainBody_compassion = preg_replace('/<\/p>/', '', $strMainBody_compassion, 1);
break;
case 6:
// Website News
$strMainActive_website = $mainRowAll["active"];
$strMainAnchor_website = $mainRowAll["displayanchor"];
$strMainTitle_website = str_replace("\r\n", "
", $mainRowAll["displaytitle"]);
$strMainBody_website = preg_replace('/
/', '', $mainRowAll["displaybody"], 1);
$strMainBody_website = preg_replace('/<\/p>/', '', $strMainBody_website, 1);
break;
case 7:
// Ministries in Session
$strMainActive_ministries = $mainRowAll["active"];
$strMainAnchor_ministries = $mainRowAll["displayanchor"];
$strMainTitle_ministries = str_replace("\r\n", "
", $mainRowAll["displaytitle"]);
$strMainBody_ministries = preg_replace('/
/', '', $mainRowAll["displaybody"], 1);
$strMainBody_ministries = preg_replace('/<\/p>/', '', $strMainBody_ministries, 1);
break;
case 8:
// Page Menu
$strMainActive_menu = $mainRowAll["active"];
$strMainAnchor_menu = $mainRowAll["displayanchor"];
$strMainTitle_menu = str_replace("\r\n", "
", $mainRowAll["displaytitle"]);
$strMainBody_menu = preg_replace('/
/', '', $mainRowAll["displaybody"], 1); $strMainBody_menu = preg_replace('/<\/p>/', '', $strMainBody_menu, 1); break; } } $query_main_menu = "SELECT * FROM PageNew_main WHERE active='y' and menuorder>0 ORDER BY menuorder ASC"; $result_main_menu = mysql_query($query_main_menu); $num_main_menu = mysql_num_rows($result_main_menu); $query_side_menu = "SELECT anchor, title FROM PageNew_side WHERE dateactive<=".date('Y-m-d')." and dateexpires>".date("Y-m-d")." and active='y' ORDER BY displayorder ASC"; $result_side_menu = mysql_query($query_side_menu); $num_side_menu = mysql_num_rows($result_side_menu); ?>
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||