Cam someone help me with deleting information from a MYSQL database.
I want to delete from one table based on information contacted in another. The code I am using at present (which does not work) looks like this:
Any help would be much appreciated. Thanks.
DELETE FROM ServedAt
Unfortunately, this kind of functionality is not available in MySQL, which does not support sub-selects. You'll have to use a script to get this done, I'm afraid. Select the list of ID's and then iterate through, deleting each one.
Do you know of any tutorial which might guide me through creating this kind of script in PHP.