Wordpress delete empty posts

Question

0

Hi!
I'd like to make this mysql command into a script and run it as a cron:

DELETE FROM xx_posts WHERE post_content=''

However, I don't know how. So the question is what should the php file look like to access and delete the empty wordpress posts from the database?
Thank you!

php

2

Contributors

2

Replies

3

Views

7 Years

Discussion Span

7 Years Ago

Last Post by wattaman

This Question has been Answered

php

Answer 1 · 2011-02-26T02:14:01+00:00

Ok,

//php file to run as cron

...db connection details...

$r = mysql_query("DELETE FROM xx_posts WHERE post_content=''");

//you could include some error or event logging too if you wanted

You should be able to set up a cronjob via cPanel or its equivalent. If you don't seem to have this facility talk to your host.

wattaman · Answer 2 · 2011-02-26T08:04:54+00:00

Thanks, that was the line I needed.