Well the only way to do this properly is a cron job.
have a look at
http://forums.devshed.com/showthread.php?threadid=13642&forumid=5

hope it helps

""MAX"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
002301c0d2c0$b49b3c00$0300a8c0@cv2">news:002301c0d2c0$b49b3c00$0300a8c0@cv2...
> Hi,
> I'm newbie from Indonesia.
> Your query has helped me to create random text using PHP and MySQL.
> Could you please give me an example script for random text, the text
changes
> in every 24 hours/every 7 o'clock in the morning not after
"refresh/reload".
>
> Thanks for your help.
>
> Max
> Indonesia
>
>
>
> ----- Original Message -----
> From: "Johannes Janson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, April 30, 2001 6:56 PM
> Subject: Re: [PHP-DB] How to randomly select data in a field. Please help
> newbie.
>
>
> > Hi,
> >
> > you could do the random selection in MysSQL if you use it
> > using a query like this.
> > SELECT  FieldWithURL FROM YourTable ORDER BY RAND() LIMIT 0,1;
> > This will give you a random field. If you want more fields you have to
> > set different values for the limit. Like LIMIT 0,5 for the first 5 row.
> > Just if you don't know the syntax of LIMIT: limit 'StartingPoint',
> > 'NumberOfRows'
> >
> > hope it helps
> > Johannes
> >
> > ""Greg K"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> > 9cfe9n$ggd$[EMAIL PROTECTED]">news:9cfe9n$ggd$[EMAIL PROTECTED]...
> > > Can someone explain to me the best way to randomly select data from
> field
> > > that consist of urls. The fields consist  urls that  are images of
> people.
> > I
> > > believe I have to setup that field as a array and turn it into a
> interger.
> > > But I have no experience doing this can someone sort of give me a
> example
> > on
> > > how I would do this .
> > >
> > > Thank you ..
> > >
> > > Your Help would be well appreciate it ..
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> > >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to