Thanks Ray
I've altered the query, but it's still wrong:
mysql_select_db($database_connRoSite, $connRoSite);
$query_rsMemRecips = "SELECT CONCAT(members.FirstName, ' ', members.Surname)AS RecipName FROM members WHERE members.MemEmail IN (" . implode(",",$_POST['MemEmail']) . ") ";
$rsMemRecips = mysql_query($query_rsMemRecips, $connRoSite) or die(mysql_error());
$row_rsMemRecips = mysql_fetch_assoc($rsMemRecips);
$totalRows_rsMemRecips = mysql_num_rows($rsMemRecips);
I now get this error message:
Notice: Undefined index: MemEmail in /home/sites/rotary-site.org/public_html/webassist/email/waue_membership_3.php on line 36 Warning: implode(): Invalid arguments passed in /home/sites/rotary-site.org/public_html/webassist/email/waue_membership_3.php on line 36 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Cheers
Chris