phpadmin - deleting row problem

quaqualita

I use phpadmin to maintain a small mysql database. Sometimes a product previously listed will not be sold anymore, then I need to delete the row of this product in the table.

I noticed that in some cases I can't delete a row (not always, really weird!). I click the 'delete' button of the row in the table.. I get the message, if I really want to delete this row - I confirm - I get the message that the row has been deleted. But when viewing the table afterwards the item I tried to delete is still there!

Can anybody tell me what I am doing wrong?

thanks in advance.

tekky

how are you verifying that the row is deleted? via a mysql query or by loading a page that lists the items? because its possible your browser has cached a page.... you can generally verify that by closing your browsers and opening up, or going to a completely new website, then manually going back to the other page not just hitting the back button

quaqualita

I verifiy within phpmyadmin, if I query to see all rows in the table, the row I deleted before is still there.

Also in the website, where the querry for this tables is running, the item I wanted to delete is still in .

tekky

can you show us a section of the database and the corresponding query that is not deleting it?

quaqualita

well.. like I said I work in phpmyadmin to modify the database.
In phpadmin when I view all rows of the table there is at the beginning of each row a 'edit' and a 'delete' button.
I click the delete button and I get the next window showing e.g.
"Do you raelly want to
DELETE FROM aabb WHERE id = '1' AND Ref = '101' "
with a 'yes' and a 'no' button beneath it. I click 'yes' and it goes back to the complete table view with all rows.

In most cases it works: the row I deleted is not there anymore. But sometimes the row is still there, without giving me any error messages that the delete querry couldn't be done.

tekky

well without anything more than that, the best I can say is, if this is a hosted website, its a problem for the site admins, if its on your local computer.... I couldnt offer anything else other than try backing up your data and reinstalling mysql/php

quaqualita

figured it out!

I checked the querry phpmyadmin creates by using the button 'delete'. The automatically created querry was

DELETE FROM aabb WHERE 'Ref' = '101'

but it should be Ref not 'Ref'

when I made the querry manually
DELETE FROM aabb WHERE Ref = '101'
it works.

So it seems that phpmyadmin or my host has a bug by putting ' ' around the column name, when using the delete button instead of typing the querry manually.

Thanks anyway for your replies, at least I knew that I didn't do anything wrong and knew were to look for the mistake.