I am trying to delete some rows from a given table using mysql and php. No errors come up, the page doesn't die, however the records are not deleted!
Here's the code
$delete_temp_query=("DELETE FROM temporary where contactemail='".$emailcheck."'"); $delete_temp=($delete_temp_query) or die(mysql_error());
The value of $emailcheck is
$emailcheck = $_POST['email'];
which is an email received from a form.
I printed the query onscreen, it states:
The query to be executed is:
DELETE FROM temporary where firstname.lastname@example.org'
I tried running this command in the phpmyadmin sql dialog and it deletes the records! (asking for a confirmation first).
Thanks in advance!