[RESOLVED] I just can't find what's wrong in syntax

[Mgccl]

$id = 1;
	$prefix = nuke;
	$query = 'SELECT '.
			'p.elo, p.team, p.win, p.lose, p.draw, p.exp, p.page_id, p.total_enemy_elo, p.total_enemy_exp, p.country_id, p.team_id, p.rank_elo, p.rank_exp, p.rank_elo_change, p.rank_exp_change, p.rank_team_elo, p.rank_team_exp, p.rank_team_elo_change, p.rank_team_exp_change, p.rank_country_elo, p.rank_country_exp, p.rank_country_elo_change, p.rank_country_country_exp_change, p.rate_power, p.rate_reputation, '.
		    'u.username, '.
		    'c.flag, c.name, '.
		    't.prefix, t.suffix, '.
		    'FROM '.$prefix.'_ladder_prof p, '.
		    $prefix.'_ladder_country c, '.
		    $prefix.'_ladder_team t '.
		    'ON p.country_id = c.id AND p.team_id = t.id'.
			'WHERE id = '.$id.' '.
		    'LIMIT 1';

I have tryied everything and too me it looks fine... BUT... I just can't find what's wrong with it.....

and.. I see most people use " instead of ' for Mysql querys... which one is better?

[Drakla]

You're using an ON clause where it doesn't belong, make it part of the where, or throw a LEFT or RIGHT join in, whatever's applicable