Hi All,

I'm using phpmyadmin to run a little blog. I was wondering if there was any way that I could enter my blog posts in the database (as I do) but set it up so that the post automatically goes "live" on a certain day. Similar to how wordress allows you to set up posts to automatically appear on the website at a certain time/date.

-worldy

Have datetime column that holds the date & time to show the data.

Then simply check the date and time when reading the database.

PHP Code:

SELECT fieldlist FROM table WHERE postactive_field > NOW(); 


thanks