$numStories = 10; $result = DB_query("Select sid, title, unix_timestamp(date) AS day FROM {$_TABLES['stories']} WHERE (date <= NOW()) AND (draft_flag = 0) AND (featured = 0) ORDER BY date DESC LIMIT $numStories"); $nrows = DB_numRows($result); for ($i = 1; $i <= $nrows; $i++) { $A = DB_fetchArray($result); $retval .= date("M d",$A['day']) . ' -- ' . stripslashes($A['title']) . '
'; } return $retval;