temporary table query

hi all I'm using this query: CREATE temporary TABLE temptable SELECT * FROM gallery INNER JOIN designers ON (designers.designersID=gallery.designersID) WHERE (LOWER(gallery.omschrijving) LIKE '%$search%' OR LOWER(gallery.productnaam) LIKE '%$search%' OR LOWER(voornaam) LIKE '%$search%' OR

Re: temporary table query

* Wilbert Enserink I'm using this query: CREATE temporary TABLE temptable SELECT * FROM gallery INNER JOIN designers ON (designers.designersID=gallery.designersID) WHERE (LOWER(gallery.omschrijving) LIKE '%$search%' OR LOWER(gallery.productnaam) LIKE '%$search%' OR LOWER(voornaam) LIKE