Trouble deleting records in MYSQL
Hi there folks
I am a novice with SQL and can't figure out how to delete records in my MYSQL database.
I use this code to select the records without any problems but don't know how I can then delete these same records from the database.
FROM `amember_members` , `amember_payments`
WHERE amember_members.member_id = amember_payments.member_id
AND amember_members.status = '0'
When I change SELECT to DELETE it comes up with an error message.
I am doing this in MYPHP and am using version 5
Thanks in advance