![]() |
![]() ![]() |
![]() |
tudsy |
![]()
Post
#1
|
Advanced Member ![]() ![]() ![]() ![]() Group: Members Posts: 246 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: ![]() ![]() ![]() ![]() |
tudsy |
![]()
Post
#2
|
Advanced Member ![]() ![]() ![]() ![]() Group: Members Posts: 246 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 |
![]()
Post
#3
|
Programming Fanatic ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 1,981 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: 15th June 2024 - 02:08 PM |