DELETE not working in database |
DELETE not working in database |
tudsy |
Sep 20 2017, 07:40 AM
Post
#1
|
Advanced Member Group: Members Posts: 248 Joined: 30-September 14 Member No.: 21,611 |
Hi
I have solved error 1044. In my script, I have the following lines: $sth = prepare('DELETE FROM subscribers WHERE emailaddress = :Email'); $sth -> bindValue(':Email', "%{$Email}%"); $sth -> execute(); When I execute the above there is no error but the record is still in the database! Can anyone help? Thanks. Adrian :shades: Unsubscribe.php ( 1.56k ) Number of downloads: 1757 unsubscribe1.php ( 2.03k ) Number of downloads: 1786 Sorrytoseeyougo.html ( 1.02k ) Number of downloads: 1745 |
tudsy |
Sep 21 2017, 01:14 AM
Post
#2
|
Advanced Member Group: Members Posts: 248 Joined: 30-September 14 Member No.: 21,611 |
Hi
It works now!!! I removed the quotes and % sign when I am binding the value. Thanks. |
CharlesEF |
Sep 21 2017, 11:40 AM
Post
#3
|
Programming Fanatic Group: Members Posts: 1,984 Joined: 27-April 13 From: Edinburg, Texas Member No.: 19,088 |
The curly braces({}) are fine but I have no idea what the percent sign (%) is or even if it applies to PHP.
|
Lo-Fi Version | Time is now: 25th September 2024 - 04:59 AM |