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