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/