I crack Photoshop!
Posts: 3
22 credits Members referred : 0
« on: Oct 10, 2006, 10:31:36 PM »
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.
Moderator Community Supporter?
Jedai Sword Master
Gender:
Posts: 6439
39458 credits Members referred : 374
It's time to use PHP5!
« Reply #1 on: Oct 10, 2006, 10:54:40 PM »
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");
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)