mickeymouse Posted December 29, 2018 Share Posted December 29, 2018 $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 Link to comment Share on other sites More sharing options...
mickeymouse Posted December 30, 2018 Author Share Posted December 30, 2018 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now