[SOLVED] SQL syntax error

[2DaysAway]

I'm getting this error:

Error: 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 '-_cartelz.ratings WHERE id='8'' at line 1

 

Here is the query:

 

$query = mysql_query("SELECT total_votes, total_value, used_ips FROM $rating_dbname.$rating_tableName WHERE id='$id_sent' ")or die(" Error: ".mysql_error());

 

I've checked my config page, the db info is correct and the table info is correct

 

Is the query written correctly?

 

 

[revraz]

Echo

 

$rating_dbname

$rating_tableName

 

See what they contain or just echo the $query and see how it looks.

[toplay]

Check the value of $rating_dbname.$rating_tableName because in the error it looks like there's a dash: -_cartelz.ratings WHERE id='8'' at line 1

 

Dashes are not allowed in table names (underscores are ok though).

 

 

[2DaysAway]

that dash is in the Database Prefix. I've been using this same database for years now with the dash.

[fenway]

that dash is in the Database Prefix. I've been using this same database for years now with the dash.

Then backticks are in order.

[2DaysAway]

ok, i added backticks:

$query=mysql_query("SELECT `total_votes, total_value, used_ips` FROM `$rating_dbname.$rating_tableName` WHERE id='$id' ")or die(" Error: ".mysql_error());

Now I get this error:

Error: Incorrect table name 'cartelz_com_-_cartelz.ratings'

 

ratings is the correct table name.

[revraz]

And your DB name is cartelz_com_-_cartelz ?

[2DaysAway]

yes, all the info is correct there.

[toplay]

$query=mysql_query("SELECT `total_votes`, `total_value`, `used_ips` FROM `$rating_dbname`.`$rating_tableName` WHERE `id` = '$id'") or die(" Error: ".mysql_error());

[2DaysAway]

same result.

[revraz]

So what changed to make it not work?

[toplay]

same result.

 

I updated my previous post. Backtick marks should be around the DB name (and table name).

 

If you get an error again, and I doubt it, always post current code/query and exact error. Thx.

 

See manual:

 

http://dev.mysql.com/doc/refman/5.0/en/identifiers.html