PHP mysql problem
Posted: Sat Jan 08, 2011 9:33 pm
hello
im new to this forum, i hope someone could help me on this...
i have a problem on updating a database...
my code is
mysql_query("UPDATE test_table SET subscribe = ' ', unsubscribe = 'True' WHERE email = '$email'");
the problem is on the records on the email column, if the record is test@test.com the email won't compare with $email (where $email has a value of test@test.com), it doesn't update the subscribe or unsubscribe column
but if the record on my email column is test and the value of $email is test it updates my database...
can anyone help on this?
im new to this forum, i hope someone could help me on this...
i have a problem on updating a database...
my code is
mysql_query("UPDATE test_table SET subscribe = ' ', unsubscribe = 'True' WHERE email = '$email'");
the problem is on the records on the email column, if the record is test@test.com the email won't compare with $email (where $email has a value of test@test.com), it doesn't update the subscribe or unsubscribe column
but if the record on my email column is test and the value of $email is test it updates my database...
can anyone help on this?