'; //Loop for as many times as there are articles in the month for ($count=1; $line_ar = db_fetch_array($result_ar); ++$count) { print'
  • '.$line_ar['title'].'
  • '; } print''; //Clear the memory (not needed?) mysql_free_result($result_ar); } function archive_data_custom ($archive_date) { //This function grabs the data from the database based on the date inputed $domain = get_domain('domain'); //Send query to DB according to the month $query_ar = "SELECT articleID, title, author FROM articles_custom, club_links WHERE rel_clubID=club_linkID AND art_date<='$archive_date' AND domain = '$domain' AND status=1 ORDER BY art_date DESC"; //$query_ar = "SELECT articleID, title, author, section FROM articles WHERE art_date='$archive_date' ORDER BY section"; $result_ar = db_query($query_ar) or die(mysql_error()); print''; //Clear the memory (not needed?) mysql_free_result($result_ar); } ?> Online Health & Fitness Magazine