Vol. 10, Issue 302 - Saturday, Oct. 29, 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 */ ?>

ALERT:

\n Urgent_Open; while ($a_row = mysql_fetch_array($results)) { if ($a_row['priority'] == '0' || $a_row['priority'] == '1') { $head = $a_row['headline']; print <<< Urgent_Bulletin

$head

\n Urgent_Bulletin; } elseif ($a_row['priority'] == '2') { print <<< Urgent_Standard

$a_row[headline]

\n Urgent_Standard; } } print <<< Urgent_Close

URGENT:

// URGENT_BULLETIN

$head

// URGENT_STANDARD

$a_row[headline]

Info | PDA/Text | Corrections | Calendars | Movies

Obituaries | Vital Stats | Weather | Surf

Back Issues

(1996-Present)
S | S | M | T | W | T | F

Sections

Local News
Features
Sports
Business
Editorial
Travel (Sunday)
Corrections

Classifieds
Wheels
Island Homes
Jobs
Government Section
Bidding Advantage
Advertise

Columns
Kauakukalahale
Dictionaries
Poll
Calendar
Movies
Special Packages
MidWeek

Subscriptions
Newsstands
Directory
PDA/Text
StarHeadlines
RSS

Contribute

The Bloomberg /
Star-Bulletin Index

The Bloomberg / Star-Bulletin Index is a price-weighted index designed to measure the performance of Hawaii-based companies. The index was developed with a base value of 100 as of December 31, 1999. A chart of the index which shows the weekly performance of its members is published weekly in the Honolulu Star-Bulletin.

Central Pacific lifts

Central Pacific Bank's parent, whose third-quarter earnings jumped 119 percent from a year earlier after buying City Bank, gained 3.2 percent this week to highlight the performance of local stocks in the Bloomberg Honolulu Star-Bulletin index. Central Pacific Financial Corp. closed yesterday at $35.59.

Alexander & Baldwin Inc., whose net income rose 43 percent, saw its shares rise 2.7 percent to $47.71 while Bank of Hawaii Corp., which posted a 4 percent rise in earnings, had its stock edge up 1.3 percent.