Hi,

I am a newbee as far as My SQL is concerned. I bought a website with a database full of products. I'd like to delete specific records. I want to delete those records with a price less than $4.95 and all products that don't have a photo.

The table is called 'goods'

Price is in the 'price' field ie. $6.95 is 695

Product photo is in the 'photoUrl' field ie. http://www.site.com/pic.jpg. The field is empty if no photo exists.

I'd like to run php and eventually make it a cron job. If someone could help me with the code, I'd appreciate it.

Regards,

Tom