<?php
$database = 'cerberus';
$username = 'cerberus';
$password = 'cerberus';
$hostname = 'localhost';

$sql = "
SELECT distinct address.address_address
FROM ticket, requestor, address
WHERE  DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= last_update_date
AND ticket_status='resolved'
AND ticket.ticket_id=requestor.ticket_id
AND requestor.suppress='0'
AND requestor.address_id=address.address_id";

mysql_connect($hostname,$username,$password) or die('error connecting to the database');
@mysql_select_db($database) or die('unable to select database');
$result = mysql_query($sql) or die(mysql_error());
$num=mysql_numrows($result);
mysql_close();

$i = 0;
while($i < $num) {
        $address_address = mysql_result($result,$i,"address.address_address");
        echo "$address_address<br/>";
        $i++;
}
?>