Maxipoint Rep Office wrote:
how add something in MySQL what is not activated immediately?
Not really a perl question but oh well :)
I wish submit form and add data in MySQL database, but it must not be visible at the web site for show data immediatelly. I wish that it will be visible after I manually activate data..
what is best and simple way to do it?
You could have a datetime column called, say, 'Public'
Then on your insert staetment set Public to NOW() + INTERVAL 1 DAY (or whatever INTERVAL you want)
Then in your public script that displays the records have it SELECT only records WHERE Public < NOW()
That's one way :)
HTH
Lee.M - JupiterHost.Net
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
