Problem with SQL

Im getting this error when i try to use register.php

You have an error in your SQL syntax near '-_nameofdb.users WHERE email = 'myemail@email.com' OR login = 'myusername'' at line 1

Not sure whats wrong.

check the info in the config file:

// these are the names for the standard table names
// !!! Important
// It's possible that your server doesn't allow the database name inside a query
// if this forms a problem don't use them here and unescape the mysql_select_db() function
// inside the connect_db() method.
define("USER_TABLE", DB_NAME.".users");
define("PROFILE_TABLE", DB_NAME.".users_profile");
define("COUNTRY_TABLE", DB_NAME.".countries"); // an optional table with countruy names and codes
define("SESSION_TABLE", DB_NAME.".sessions");

:/ i did that already and it all seems ok....

PS: Thanks for the timely response

:/ i did that already and it all seems ok....

PS: Thanks for the timely response

does it work now?

Nope it still doesnt seem to work...

Nope it still doesnt seem to work...

you server doesn't support this kind of table calls: dbname.tablename

remove the leading DB_NAME.". from the statements and uncomment the mysql_select_db function from the db_connect method (this is the information I posted before)

[Guest]

[62.869]

Googlebot, Yahoo crawler, Msnbot