Hi all, I know this is rather OT, but I searched the mySQL manual all over...couldn't find it. I want to perform a search in a table. More then 1 columns should be searched. namely column1 and column2 and so on. Anybody knows what goes wrong here? --(in the WHERE clause). It seems that mySQL doesn't like to perform a search in more then 1 column.:-(
$query="SELECT * FROM gallery LEFT JOIN designers ON (designers.designersID=gallery.designersID) WHERE (gallery.column1, gallery.column2) LIKE '%$search_string%' ORDER BY gallery.galleryID"; thx for any advice ------------------------- Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] -------------------------