I have the follwoing error when I member attempts to read their PMs.
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]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 '[IGNORE_PM]='Admin' AND MEMBER_ID=3' at line 1
/forums/pm_view.asp, line 245
pm_view.asp line 244 - 246 reads:
244 Set rsFrom = my_Conn.Execute(strSql) 245 set rsIgnore = my_conn.execute("SELECT * FROM " & strTablePrefix & "PM_IGNORE WHERE [IGNORE_PM]='" & rsFrom("M_NAME") & "' AND MEMBER_ID=" & MemberID) 246 if not rsIgnore.EOF then
Here's a Screenshot of my current tables in table PM_IGNORE;
I'm guessing it has something to do with M_NAME but I'm no expert. Any help/guidance would be appreciated.
Topic Locked
Posted - 19 October 2004 : 17:25:22
