@ issue (seeking experience before i blindly proceed)
Posted: Thu Aug 21, 2003 2:08 pm
the debugging info returned when i added a few lines because nothing was being inserted:
the last line is the return from mysql_escape_string() on the variable containing the e-mail address. in the input it is put through a funtion that uses the php addslashes($variable) before returning it to set it for the db.
obviously it needs to not be in the form of @. i'm wondering (since i can't find anything online or in the oreilly book that is specifically on this. they all talk about escapes in general) if \@ would work.
(in the mean time i'm going to look up the ascii value of @)
i edited out my e-mail address. nothing else.debug: insert to user: INSERT INTO users (username, password, email, last_login_ip, last_login_date, enroll, gender) VALUES (Neo, 9cc9e1f6a22e05307d6831087ef5d1e6, edited_out@hotmail.com, 192.168.1.100, 2003-08-21 19:06:06, 2003-08-21 19:06:06, M)
1064
You have an error in your SQL syntax near '@hotmail.com, 192.168.1.100, 2003-08-21 19:06:06, 2003-08-21 19:06:06, M)' at line 1
edited_out@hotmail.com
the last line is the return from mysql_escape_string() on the variable containing the e-mail address. in the input it is put through a funtion that uses the php addslashes($variable) before returning it to set it for the db.
obviously it needs to not be in the form of @. i'm wondering (since i can't find anything online or in the oreilly book that is specifically on this. they all talk about escapes in general) if \@ would work.
(in the mean time i'm going to look up the ascii value of @)