well i ran the query:
I ran the query:
INSERT INTO subscribeforum (userid, forumid, emailupdate) VALUES (10, 13, 1)
This does not cause an error message, and does add a subsription. but if you use "1" for email notification, it does not send an email, however using 2 and 3 do send emails.
ALSO noticed: if any of VALUES (x, y, z) match what is already in the table I get the following error:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1062
error desc: Duplicate entry '13-10' for key 2
do i need a dump table command or something?
|