mysql syntax error I can't find why

Frihost Forum Index -> Scripting -> Php and MySQL

Quote:

$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?

SpellcasterDX

Don't you have to put CREATE TABLE_blah_XX or Insert into TABLE_blah_XX? Confused

hexkid

Mgccl wrote:

$query = 'SELECT '.
// ... columns
'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.....

You're not using the correct JOIN syntax.
I don't like JOINs, so I can't help you with it. I usually only use WHERE and let the server have all the work Smile

Code:

SELECT columns FROM table1, table2, table3, ...
WHERE table1.x=table2.y and table2.x=table3.y ...

I think the above query can be specified with JOINs as

Code:

SELECT columns FROM table1 JOIN table2 ON table1.x=table2.y JOIN table3 ON table2.x=table3.y ...

Mgccl wrote:

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

The better is the one you like best!
I usually use single quotes for everything except SQL statements Smile

compare

Code:

$sql = "select * from tbl where id=$id";
$sql = 'select * from tbl where id=' . $id;

Frihost Forum Index -> Scripting -> Php and MySQL