<?php

// mysql variables
$host='localhost';
$user='root';
$pass='mypass';
$database='pager';

// Only find matching (with wildcard)
$query1 = "SELECT *
FROM feed, recipients
WHERE feed.title LIKE concat('%', recipients.suburb, '%')
ORDER BY pubDate DESC";

// Make a MySQL Connection
$db = mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

// Start script to send SMS/eMail
$recipients = "SELECT * FROM recipients ORDER BY id DESC";
$email_list = mysql_query( $recipients );
$result = mysql_query($query1)
or die(mysql_error());
$row2 = mysql_fetch_array( $result );
foreach($email_list as $row)

// actual email
$to = $row['email'];
$subject = "Page: ". $row2['title'];
$body = $row2['description'];
if (mail($to, $subject, $body)) {
  echo("<p>Message successfully sent!</p>");
 } else {
  echo("<p>Message delivery failed...</p>");
 }
?>