select statements

[julian haffegee]

Hi all,

I have a database of names and email addresses, that I want to email.

$result = mysql_query("SELECT emailAddress FROM subscribers_html WHERE
mailingGroup='$toText'");

The select statement needs to return a row when  mailingGroup='$toText', but
$toText is an array. How should I write this select to say where
mailingGroup is an element of the array $toText. Currently it works for
arrays with 1 element only.

I could turn the array into a string, but I wondered if there was a clever
MySQL way of doing it all as a select

Thanks for your help!

Jules