könnt ihr mir bitte mal helfen?
Ich habe diesenFehler:
MySQL Error: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `ic1_liga_teamuser` b INNER JOIN `ic1_user` a ON a.id = b.uid WHERE b.tid =' at line 1 in Query: SELECT b.uid, a.icq, a.avatar, a.status, IF(a.playername='',a.name,a.playername) as playername, a.staat, b.fid, b.joined, FROM `ic1_liga_teamuser` b INNER JOIN `ic1_user` a ON a.id = b.uid WHERE b.tid = 2 ORDER BY b.fid, a.name Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ teams.php:16 -- db_query(...) @ teams.php:80 -- show_members(...) @ liga.php:48 -- require_once(...) @ index.php:24 -- require_once(...) Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /users/liga/www/test/include/includes/func/db/mysql.php on line 58
der Code aus der php Datei schaut so aus:
$q = "SELECT b.uid, a.icq, a.avatar, a.status, IF(a.playername='',a.name,a.playername) as playername, a.staat, b.fid, b.joined, FROM `prefix_liga_teamuser` b INNER JOIN `prefix_user` a ON a.id = b.uid WHERE b.tid = " . $tid . " ORDER BY b.fid, a.name";
$erg = db_query($q);
