Re: grabbing data and auto email set users
| From: | JeRRy | Date: | Mon, 10 Apr 2006 04:18:49 +0000 |
| Subject: | Re: grabbing data and auto email set users | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41674@lists.php.net to get a copy of this message | ||
Hi,
I used the following but got this error:
Fatal error: Call to undefined function: db_fetch() in
/home/tassie/public_html/tipping/admin/check.php on line 7
Any help please?
J
$query = "select * from users";
$result = mysql_query($query);
while($row = db_fetch($result)) {
$query_two = "select 1 from round_table where userid=" . $row['userid'];
$result_two = db_query($query_two);
$has_tipped = db_fetch($result_two);
// if has_tipped is empty, there have been no tips placed by this user.
if (empty($has_tipped)) {
mail($row['email'], 'you need to tip'.......
}
}
done!
--
Postgresql & php tutorials
http://www.designmagick.com/