$info = "SELECT ".$tname." AS tn, t1.teamid, ".$ncountry." as cn, c1.flag, ".$tcity." as cityn
FROM team AS t1
INNER JOIN city AS c2 ON ".$tname." LIKE '$queryString%' and t1.cityid=c2.cityid
INNER JOIN country AS c1 ON c2.countryid=c1.countryid
ORDER BY ".$tname."";
...и
$info = "SELECT ".$tname." AS tn, t1.teamid, ".$ncountry." as cn, c1.flag
FROM team AS t1
INNER JOIN country AS c1 ON ".$tname." LIKE '$queryString%' and t1.cityid=0 and ".$tname."=".$ncountry."
ORDER BY ".$tname."";
Я решил немного подсократить код:
$qfilds="SELECT ".$tname." AS tn, t1.teamid, ".$ncountry." as cn, c1.flag, ".$tcity." as cityn";
$qinner="INNER JOIN city AS c2 ON ".$tname." LIKE '$queryString%' and t1.cityid=c2.cityid
...И
$qfilds="SELECT ".$tname." AS tn, t1.teamid, ".$ncountry." as cn, c1.flag";
$qinner="INNER JOIN country AS c1 ON ".$tname." LIKE '$queryString%' and t1.cityid=0 and ".$tname."=".$ncountry."";
Вставляя это добро в составную строку запроса:
$info = $qfilds. "FROM team AS t1 ".$qinner." ORDER BY ".$tname."";
Но так не работает, похоже где-то промахнулся с кавычками, но никак не могу понять где(((