SailMichigan.org News http://www.sailmichigan.org/newsfeed.php A resource for sailing news and information through out the state of Michigan. en-us'; $query = "SELECT * FROM sm_news WHERE news_publish = 'Y' order by news_date DESC limit 20"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)) { $year = substr($row["news_date"], 0, 4); $month = substr($row["news_date"], 5, 2); $day = substr($row["news_date"], 8, 2); $hour = '00'; $min = '00'; $sec = '00'; $pubdate = date('D, d M Y H:i:s O', mktime($hour, $min, $sec, $month, $day, $year)); $items .= ' '. $row["news_title"] .' '; if($row["news_link"]) { $items .= ' ';} $items .= ' '; $items .= ' '. $pubdate .' '; } $items .= ' '; echo $items; ?>