$q = "SELECT * FROM users WHERE active= 'Y'"; $r=mysql_query($q) or die(mysql_error()); $num=mysql_num_rows($r); if($num > 0) while($row = mysql_fetch_assoc($r)) { $useremail = $row['email']; // The message $message = "This is a message to all our users."; $message = wordwrap($message, 70, "\r\n"); // Send mail('$useremail', 'My Subject', $message); }