ciao,
io ho qusta query che funziona benissimo

$db->sql_query("(SELECT id, title as titleall, consol, genere, eudate, hits FROM ".$prefix."_Games) union all (SELECT id, title2 as titleall, consol, genere, eudate, hits FROM ".$prefix."_Games Where title2<>'' ) ORDER by titleall");


soltanto che non funziona se io metto la stessa query in quest altra query (che funziona)

$result = $db->sql_query("SELECT id, title, consol, genere, eudate, hits FROM ".$prefix."_Games WHERE UPPER(title) LIKE $select $showconsol ORDER by title $order");

cosi ottengo dovrei ottenre quasta

$result = $db->sql_query("(SELECT id, title as titleall, consol, genere, eudate, hits FROM ".$prefix."_Games) union all (SELECT id, title2 as titleall, consol, genere, eudate, hits FROM ".$prefix."_Games Where title2<>'' ) WHERE UPPER(title) LIKE $select $showconsol ORDER by titleall $order");

ma non funziona sapreste dirmi dove sbaglio