How to compare a string with array-elements in a WHERE-clause? Hi!
I do have a string in a table and i do have an array from a muliselect-field out of an html-site. The string of the table is one of about 20 possible strings, the array could contain no, one or more of these strings. I have tried this MysqlQuery( "SELECT * FROM $db_angebotetabelle WHERE (( $multiselect == '') OR ($db_mytable.TheOneString IN ('$multiselect')) ORDER BY TheOneString ") Which doesn't work ): Could you help me, please? Dieter Hansen [EMAIL PROTECTED] ________________________________________________________________ Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr! Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13 --------------------------------------------------------------------- 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