/
// revised 2005-09-03
/*
require('breaking.config.php');
$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
$nonurgent_query = "select * from breaking where date >= '" . $period_date . "' and (priority = '3' || priority = '4')
and visible = 'Yes' order by priority, date desc";
$results = mysql_query($nonurgent_query);
$numrows = mysql_num_rows($results);
// DISPLAY NON-URGENT NEWS
if ($numrows >= 1) {
print <<< NonUrgent_Open
News Updates
\n\n
NonUrgent_Open;
while ($a_row = mysql_fetch_array($results)) {
if ($a_row['priority'] == '3') { // Update (red)
print <<< NonUrgent_Bulletin
\n
NonUrgent_Bulletin;
} else if ($a_row['priority'] == '4') { // Update (blue)
print <<< NonUrgent_Standard
\n
NonUrgent_Standard;
}
}
print <<< NonUrgent_Close
(1996-Present)
M | T | W | T | F | S | S
Sections
|  |
 |
Hawaii News
Features
Sports
Business
Editorial
 |
| |
/
// revised 2006-01-20
error_reporting(0);
require('breaking.config.php');
$breaking_urgent = FALSE;
// CONNECT TO MySQL
$link = mysql_connect($mysql_host);
if ( ! $link ) die ("");
@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 URGENT, 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 URGENT
if ($numrows >= 1) {
while ($a_row = mysql_fetch_array($results)) {
if ($a_row['priority'] == '0' || $a_row['priority'] == '1') {
$head = $a_row['headline'];
$breaking_urgent .= <<< Urgent_Bulletin
| » |
$head | \r\n
Urgent_Bulletin;
} elseif ($a_row['priority'] == '2') {
$breaking_urgent .= <<< Urgent_Standard
| » |
$a_row[headline] | \r\n
Urgent_Standard;
}
}
}
// CLOSE MYSQL CONNECTION
mysql_close($link);
if ($breaking_urgent) {
$breakingurgent = <<
|
Breaking_Urgent;
$breakingurgent .= "
$breaking_urgent\r\n
";
$breakingurgent .= <<
Breaking_Urgent;
echo $breakingurgent;
} else {
echo "";
}
error_reporting(E_ALL);
?>
 |
June Watanabe |  |
Corky Trinidad |  |
S-B Photographers |  |
Richard Brislin |
|
|
|
|
|  |
