I crack Photoshop!
Posts: 3
22 credits Members referred : 0
« on: Oct 10, 2006, 09: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: 6691
34714 credits Members referred : 374
It's time to use PHP5!
« Reply #1 on: Oct 10, 2006, 09: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");
I crack Photoshop!
Posts: 3
22 credits Members referred : 0
« Reply #2 on: Oct 11, 2006, 12:30:49 am »
:/ i did that already and it all seems ok....
PS: Thanks for the timely response
Moderator Community Supporter?
Jedai Sword Master
Gender:
Posts: 6691
34714 credits Members referred : 374
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)
Trackback URI for this entry : http://www.webdigity.com/trackback.php?topic=4403