Welcome to Simpits International

= '".$back90."'"; return $retval; } function calc_range() { // returns a SQL WHERE clause based on the current month. $month = date("M"); $year = date("Y"); switch($month) { case "Jan": $retval = " WHERE date_approved >= '".$year."-01-01' AND"; $retval .= " date_approved <= '".$year."-01-31' "; break; case "Feb": //28 $retval = " WHERE date_approved >= '".$year."-02-01' AND"; $retval .= " date_approved <= '".$year."-02-28' "; break; case "Mar": //31 $retval = " WHERE date_approved >= '".$year."-03-01' AND"; $retval .= " date_approved <= '".$year."-03-31' "; break; case "Apr": //30 $retval = " WHERE date_approved >= '".$year."-04-01' AND"; $retval .= " date_approved <= '".$year."-04-30' "; break; case "May": //31 $retval = " WHERE date_approved >= '".$year."-05-01' AND"; $retval .= " date_approved <= '".$year."-05-31' "; break; case "Jun": //30 $retval = " WHERE date_approved >= '".$year."-06-01' AND"; $retval .= " date_approved <= '".$year."-06-30' "; break; case "Jul": //31 $retval = " WHERE date_approved >= '".$year."-07-01' AND"; $retval .= " date_approved <= '".$year."-07-31' "; break; case "Aug": //31 $retval = " WHERE date_approved >= '".$year."-08-01' AND"; $retval .= " date_approved <= '".$year."-08-31' "; break; case "Sep": //30 $retval = " WHERE date_approved >= '".$year."-09-01' AND"; $retval .= " date_approved <= '".$year."-09-30' "; break; case "Oct": //31 $retval = " WHERE date_approved >= '".$year."-10-01' AND"; $retval .= " date_approved <= '".$year."-10-31' "; break; case "Nov": //30 $retval = " WHERE date_approved >= '".$year."-11-01' AND"; $retval .= " date_approved <= '".$year."-11-30' "; break; case "Dec": //31 $retval = " WHERE date_approved >= '".$year."-12-01' AND"; $retval .= " date_approved <= '".$year."-12-31' "; break; } return $retval; } ?> Welcome to Simpits International \n"; print "\n"; print "

\n"; print "\n"; print "\n"; print "\n"; // build the top of the news box print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "

\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "

\n"; // news block begins here print "

\n"; print "
\n"; // // select news from the current month and then iterate through each // available day // $query = "SELECT * from daily_news ". calc_range90() ." and approved='Y' ORDER BY date_submitted DESC"; $result = mysql_query($query); if (!$result) { echo mysql_error(); print "
Q: $query\n
"; exit; } while ($line = mysql_fetch_assoc($result)) { // // display code // one table/div pair per news item // print "\n"; print "\n"; // // date block // this should be sent once per news day // if ($hold_date <> $line[date_approved]) { $hold_date = $line[date_approved]; print "\n"; print "\n"; print "

\n"; print " ".date("dMy",strtotime($line[date_approved]))."\n"; print "

\n"; } else { // print an empty block print "

\n"; print "

"; } // // headline & body block. // print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "

\n"; print " $line[headline]\n"; print "

\n"; print "\n"; // print strftime("%H:%I",$line[time_approved])."\n"; print substr($line[time_approved],0,5); print "\n"; print "

\n"; print "

\n"; print "\n"; print "\n"; print "\n"; print "\n"; // // submitter block // print "\n"; print "\n"; print "\n"; print "

\n"; print "

\n"; // // news item body // print $line[news_text]."\n"; // // end news item body // print "

\n"; print "

\n"; print "$line[submitted_by]\n"; print "

\n"; print "

\n"; } // end while... // draw left line print "

\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "

\n"; mysql_close($link); ?>

--------->>>> Home / Articles / Database / Files / Member / About / Join / Webring / Chat