require_once('Connections/myconn.php'); mysql_select_db($database_myconn,$myconn); $siteTitle = 'Articles and News - '; require_once('header.php'); ### FETCH NEWS ORDER BY DATE ASC $newssql = 'SELECT *,Date_Format(`date`,"%m/%d/%y") as `date` FROM `news` order by `date` asc'; $newsR = mysql_query($newssql,$myconn) or die(mysql_error()); ### FETCH FEATURED NEWS FROM SETTINGS $settingsSql = 'select * from settings where id = 1'; $settingsR = mysql_query($settingsSql,$myconn) or die(mysql_error()); $settings = mysql_fetch_assoc($settingsR); $featuredSql = 'select * from news where id = '.$settings['defaultNewsID']; $featuredR = mysql_query($featuredSql,$myconn) or die(mysql_error()); $featured = mysql_fetch_assoc($featuredR); ?>
|