StarBulletin.com
Vol. 10, Issue 306 - Wednesday, November 2, 2005
/ // revised 2005-09-03 require('breaking.config.php'); // CONNECT TO MySQL $link = mysql_connect($mysql_host); if ( ! $link ) die ("Couldn't connect to MySQL"); @mysql_select_db($mysql_database,$link); // DETERMINE PERIOD_DATE, 24 HOURS AGO $today = date('ymdHis'); $p1_query = "select date_add('" . $today . "' , interval -24 hour)"; $p1_result = mysql_query($p1_query); while ($p_row = mysql_fetch_row($p1_result)) { foreach ($p_row as $field) $period_date = $field; } // DETERMINE PERIOD_MONTH, 2 MONTHS AGO $p2_query = "select date_add('" . $today . "' , interval -2 month)"; $p2_result = mysql_query($p2_query); while ($p2_row = mysql_fetch_row($p2_result)) { foreach ($p2_row as $field) $period_month = $field; } // SEARCH NON-URGENT NEWS, 24 HOURS AGO, PRIORITY 0, 3, & 4 $urgent_query = "select * from breaking where date >= '" . $period_date . "' and priority <= '2' and visible='Yes' order by priority, date desc"; $results = mysql_query($urgent_query); $numrows = mysql_num_rows($results); // DISPLAY NON-URGENT NEWS if ($numrows >= 1) { print <<< Urgent_Open \n Urgent_Close; } else { print "\n\n"; } // CLOSE MYSQL CONNECTION mysql_close($link); exit; /* FORMAT FOR URGENT */ ?>