In my script I have
if($variable == 0 && $othervariable == 0)
{mysql_query("INSERT INTO table_name VALUES ('x', 'x', 'x')");
then continues with two email scripts }
variable and other variable are actually mysql_num_rows for two searches that I performed.
Both emails get sent, and I have more database entries after the email scripts. Everything works EXCEPT what I posted above. All the info to be entered is correct, I am attempting to enter the same number of columns as the table has, the emails would not be sent if my two variables did not work, so I cannot figure out why only that one entry is not working. If anyone has any advice please post it.
Thanks but thats not it. I insert rows all the time without specifying the columns. As long as you have, say 3 rows, and 3 sets being entered it works. In fact the next two rows I mention that I enter and work, do not have specified columns.
I have no idea what is going on so Im rewriting the script and double checking every step by echoing it out and making sure it enters the database. Which is kind of horrible because the entire thing is like 70 pages long on wordpad...
if($variable == 0 && $othervariable == 0)
{mysql_query("INSERT INTO table_name VALUES ('x', 'x', 'x')");
then continues with two email scripts }
variable and other variable are actually mysql_num_rows for two searches that I performed.
Both emails get sent, and I have more database entries after the email scripts. Everything works EXCEPT what I posted above. All the info to be entered is correct, I am attempting to enter the same number of columns as the table has, the emails would not be sent if my two variables did not work, so I cannot figure out why only that one entry is not working. If anyone has any advice please post it.
Thanks but thats not it. I insert rows all the time without specifying the columns. As long as you have, say 3 rows, and 3 sets being entered it works. In fact the next two rows I mention that I enter and work, do not have specified columns.
I have no idea what is going on so Im rewriting the script and double checking every step by echoing it out and making sure it enters the database. Which is kind of horrible because the entire thing is like 70 pages long on wordpad...