Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // mysql variables
- $host='localhost';
- $user='root';
- $pass='mypass';
- $database='pager';
- // SQL Queries
- $query1 = "SELECT *
- FROM feed, recipients
- WHERE feed.title LIKE concat('%', recipients.suburb, '%')
- ORDER BY pubDate DESC";
- $recipients = "SELECT *
- FROM recipients
- ORDER BY id 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
- $result = mysql_query($query1);
- $result2 = mysql_query($recipients);
- $row = mysql_fetch_array( $result2 );
- $row2 = mysql_fetch_array( $result );
- foreach($result2 as $row);
- // actual email
- $to = $row['email'];
- $subject = "Page: ". $row2['title'];
- $body = $row2['description'];
- if (mail($to, $subject, $body)) {
- echo("<p>sent!</p>");
- } else {
- echo("<p>failed!</p>");
- }
- ?>
- ERROR:
- Warning: Invalid argument supplied for foreach() in /var/whirltools/www/email.php on line 28
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement