Jump to content
mickeymouse

Delete not deleting.

Recommended Posts

$query = "DELETE * FROM names WHERE `Ref` = '$ref' ";

`Ref` is field 0 in my Database and I have an item whose `Ref` is "0001"

and my $ref = "0001".

But my item is not getting deleted.

The  $AffectedRows = -1

There are no error messages.

What is wrong with my $query statement?

Tks

Share this post


Link to post
Share on other sites

OK.  Found my problem.

It was the asterisk "*" which I had after the word DELETE.

I thought I needed the "*" to signify delete all if more than one with the same criteria.

Thank you.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×