SQL syntax error

hallo @all,

i'm testing with the new version (16-05-2007) of class, but all time i get this error by testing the login.php:

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 '-usermanager.users WHERE BINARY login = 'administrator' AND pw = 'c055ca7ac876e8' at line 1

and for register.php:

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 '-usermanager.users WHERE email = 'testman@abc.com' OR login = 'testman'' at line 1

Please, have somebody a tip for me, what is false?
thank you!

[Join us @ facebook]

I guess that - is the problem

thank you very much!

your tip is right!
my database name was "ew-usermanager" and the "-" was probably the problem.
now, i did rename the db to "usermanager" and all is running.

thank you for the very quick answer!

I am trying to register the user with your version 1.97

my host provider doesn't allow me to change this part of my database tables name

<site name>_com_-_<table name> is the format, how do i get around this? explicitly list the value in the class?

Code:

'-_example.users1 WHERE email = 'test@test.com' OR login = 'test'' at line 1

I have a phpNuke site running also on this site (a few of them) as well, and they have the database name with the dash in it and it works just fine... what's going on here?

[Free WordPress Themes]

I am trying to register the user with your version 1.97

my host provider doesn't allow me to change this part of my database tables name

<site name>_com_-_<table name> is the format, how do i get around this? explicitly list the value in the class?

Code:

'-_example.users1 WHERE email = 'test@test.com' OR login = 'test'' at line 1

I have a phpNuke site running also on this site (a few of them) as well, and they have the database name with the dash in it and it works just fine... what's going on here?

check this part from the class:

inside 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.

inside the class file:
   function connect_db() {
      $conn_str = mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD);
      mysql_select_db(DB_NAME); // if there are problems with the tablenames inside the config file use this row
   }

[Guest]

[36.294]

Yahoo crawler, Baidu Spider, Googlebot