22, November 2008

Problem with SQL - webmaster forum

 
Webdigity webmaster forums
This forum shares its ad revenue with its members!
[ Home | Help | Search | Forum's Shop | Archive | Login | Register | Webmaster Directory ]
Webdigity Webmaster Forums  >  Web Development  >  PhP  >  PHP classes @finalwebsites.com  >  Access_user Class (Moderator: Olaf)
Topic: Problem with SQL
« previous next »
Pages: [1] Print

Author Topic: Problem with SQL  (Read 1106 times)
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: Male
Posts: 6440
39464 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");


Last blog : Just a better Internet portal provided by Google
I crack Photoshop!
*
Posts: 3
22 credits
Members referred : 0


« Reply #2 on: Oct 11, 2006, 01: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: Male
Posts: 6440
39464 credits
Members referred : 374


It's time to use PHP5!


« Reply #3 on: Oct 11, 2006, 07:40:36 AM »

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

PS: Thanks for the timely response
does it work now?


Last blog : Just a better Internet portal provided by Google
I crack Photoshop!
*
Posts: 3
22 credits
Members referred : 0


« Reply #4 on: Oct 11, 2006, 03:44:15 PM »

Nope it still doesnt seem to work...
Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6440
39464 credits
Members referred : 374


It's time to use PHP5!


« Reply #5 on: Oct 11, 2006, 05:17:56 PM »

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)


Last blog : Just a better Internet portal provided by Google
Trackback URI for this entry : http://www.webdigity.com/trackback.php?topic=4403
Tags : databases email Bookmark this thread : Digg Del.icio.us Dzone more....

Topic sponsors:
Get a permanent link here for $1.99!


Pages: [1] Print 
Webdigity Webmaster Forums  >  Web Development  >  PhP  >  PHP classes @finalwebsites.com  >  Access_user Class (Moderator: Olaf)
Topic: Problem with SQL
« previous next »
Jump to:
User Area
Welcome, Guest. Please login or register.
Did you miss your activation email?
Nov 22, 2008, 12:14:19 PM





Login with username, password and session length

Donate to our community, and get a permanent link back to your site!

Donate to our community, and get a permanent link back to your site!


Forum Statistics
Total Posts: 37.736
Total Topics: 7.650
Total Members: 4.396
Tutorials : 56
Resources : 143
Designs : 220
Latest Member: thomas09

36 Guests, 5 Users online :

12 users online today:



Readers

Web Design Gallery · Whois Lookup · Pagerank · Tag Browsing · Lo-fi version · Syndication · Webmaster forum history · Advertise
Developed by HumanWorks © 2005 - 2008 Webdigity webmaster community · sublime directory
Webdigity Webmaster Forums | Powered by SMF 1.0.12. © 2001-2005, Lewis Media. All Rights Reserved.