Results 1 to 11 of 11
Feb 18, 2011, 04:13 #1
- Join Date
- Dec 2005
- 0 Post(s)
- 0 Thread(s)
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