order/group query

, instead the order is determined by recordID... meaning (2,5,17,33,99) Any clues??:-) thx in advance! Many regards, Wilbert Enserink sql,query,queries,smallint - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl

select using 2 left joins

be much appreciated. thx in advance. Wilbert Enserink - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED

mysql query: left join with same column names

?? Or are there other solutions? thx Wilbert Enserink - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before

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

temporary table

hi all, i have this php script which queries a table. The results are stored in a temprrary table CREATE temporary TABLE t1 SELECT .statements...; when I query this table in the same script i can see that the results wore indeed stored in t1. however when i call this table from a

WHERE MATCH () AGAINST ('%$search_string%');

hi all, i'm new to this list. currently busy with mysql. I'm having troubles with the query string below. The part MATCH results in an error: Can't find FULLTEXT index matching the column list however it looks like i'm doing the query according to the manual. Anybody has any clue what's going