this is good idea, but in some cases I must have more control. If I set interval 15 days and user pay me fee I must activate it immediately or if user is not pay I must delete it..
have someone another more strict way? -----Original Message----- From: JupiterHost.Net [mailto:[EMAIL PROTECTED] Sent: Saturday, August 28, 2004 6:49 PM To: Maxipoint Rep Office Cc: [EMAIL PROTECTED] Subject: Re: how add something in MySQL what is not activated immediately 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>
