Perhaps your array items don't have quotes? For example... Is this what your array looks like: $toTxt = array("a","b","c")
Or is it this: $toTxt = array("\'a\'","\'b\'","\'c\'") For this to work, it needs to be the second one. If necessary, you can just walk through the array, adding the quotes: <? $toTxt = array("a","b","c"); function AddQuotes (&$arrItem,$key) { $arrItem = "'$arrItem'"; } array_walk($toTxt,'AddQuotes'); $toTxt = implode($toTxt,","); $sql = "select * from table where field value in ($toTxt)"; ?> Does that work? HTH! Jed On the threshold of genius, Ian Osterberg wrote: > Thanks Jed, > > I'm still stuck though > > I did as you suggested > > ----- Original Message ----- > From: "Jed Verity" <[EMAIL PROTECTED]> > To: "julian haffegee" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, September 06, 2002 3:42 AM > Subject: Re: select statements > > >> Hello, Jules, >> >> You can use the "value in (a,b,c)" format. If necessary, implode your > array >> and do something like this: >> >> SELECT emailAddress FROM subscribers_html WHERE mailingGroup value in >> ($toText); >> >> Check the documentation, if necessary, for usage of implode and "value > in". >> >> HTH! >> Jed >> >> On the threshold of genius, julian haffegee wrote: >> >>> 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 >>> >>> >>> --------------------------------------------------------------------- >>> Before posting, please check: >>> http://www.mysql.com/manual.php (the manual) >>> http://lists.mysql.com/ (the list archive) >>> >>> To request this thread, e-mail <[EMAIL PROTECTED]> >>> To unsubscribe, e-mail > <[EMAIL PROTECTED]> >>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >>> >>> >> >> >> --------------------------------------------------------------------- >> Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail > <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php