Well, I got wrapped around the "Island" axle.... dang it.

The MySQL query works good. But I'm messing up when I insert it into a Custom Island. I've never really gotten the hang of exactly HOW it works. PHP at top, HTML at bottom. But.... ?

Do I need to add <? PHP or $Query ="
(Oh, I did look at all of the samples out on the Wiki, but couldn't extrapolate a solution.)

Here's a start:

Code
/* PHP CODE HERE, IF NECESSARY */

<?PHP
DELETE *
FROM "abc_org_-_chat".ubbt_TOPICS
WHERE forum_id = 22
AND TOPIC_LAST_REPLY_TIME < (unix_timestamp(now()) - 5184000)
?>

/* DO NOT CHANGE THE LINE BELOW */
$body = <<<EOF

<img src="http://abc.org/forum/images/test.jpg" width="108" height="25" align=center alt="Time Flys!">HelloWorld

EOF;
/* DO NOT CHANGE THE LINE ABOVE */

Or, is it more like this?
Code
/* PHP CODE HERE, IF NECESSARY */

<?PHP
$query = ("DELETE *
FROM "abct_org_-_chat".ubbt_TOPICS
WHERE forum_id = 22
AND TOPIC_LAST_REPLY_TIME < (unix_timestamp(now()) - 15552000)")
?>

/* DO NOT CHANGE THE LINE BELOW */
$body = <<<EOF

<img src="http://abc.org/forum/images/test.jpg" width="108" height="25" align=center alt="Time Flys!">HelloWorld

EOF;
/* DO NOT CHANGE THE LINE ABOVE */

--BIll B