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]

Reply via email to