I have the following trigger:

CREATE TRIGGER TRIG_RAW_IPLINK_EVENT FOR RAW_IPLINK ACTIVE
AFTER INSERT OR UPDATE POSITION 1
AS
  DECLARE VARIABLE iplink char(4);
  DECLARE VARIABLE received varchar(40);
  DECLARE VARIABLE eventstring varchar(44);
BEGIN
  iplink = cast(new.IPLINK as char(4));

  eventstring = 'RAW:' || iplink;
  post_event eventstring;
END^

So, what I THINK happens - is on any insert or update (and on this table it's only inserts) I should be generating events named RAW:1116, or whatever iplink happens to be.  new.iplink is a smallint that is always 4 digits.

Assuming I've got that part right - over in php land I have the following.  Obviously I'm doing something wrong - I just have no clue what yet.  The output of the below gives me my two sanity checks - but nothing from the loop.

$iplink_node = 1116;
$dbh = ibase_connect( 'test.fdb', 'SYSDBA', 'masterkey', 'ASCII' );

echo "Database handler $dbh\n";

$evs = "RAW:$iplink_node";
echo "Event is $evs\n";

while ( $handler = ibase_wait_event( $dbh, "raw_line_handler" ) ) {
    // just keep looping...just keep looping...
    echo "$handler looped\n";
    flush();
    sleep(1);
}

function raw_line_handler( $event_name, $dbh ) {
    $iplink_node = substr( $event_name, 4, 4 );

    echo "iplink is $iplink_node\n";

    $qs = "select first RAWLINE from RAW_IPLINK where IPLINK=? order by RECEIVED desc";

    $qh = ibase_query( $dbh, $qs, $iplink_node );

    if ( $qh ) {
        while ( $row = ibase_fetch_row( $qh ) ) {
            echo $row[0];
        }
    }
    return true;
}

-- 
Daniel