The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

> DELETE not working in database
tudsy
post Sep 20 2017, 07:40 AM
Post #1


Advanced Member
****

Group: Members
Posts: 166
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: Attached File  Unsubscribe.php ( 1.56k ) Number of downloads: 448
Attached File  unsubscribe1.php ( 2.03k ) Number of downloads: 460
Attached File  Sorrytoseeyougo.html ( 1.02k ) Number of downloads: 423
Attached Image
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
 
Reply to this topicStart new topic
Replies
tudsy
post Sep 21 2017, 01:14 AM
Post #2


Advanced Member
****

Group: Members
Posts: 166
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.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Posts in this topic


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 16th December 2018 - 05:20 AM