On Wed, 23 May 2001, Don Read wrote:
> > <!-- end -->
> > </script>
> > <form>
> >
> > <?php
> > while($row = mysql_fetch_object($result))
>
> Do you plan on executing a mysql_query() some time before this ?
Actually it is executed before this. This scripts works fine on my local
host running php 4.0.1pl2. Every time I refresh the page a different
record appears. This is what I want.
I was told that order by RAND() does not work on mysql 3.22 but a work
around was RAND() as r and order by r. I tried this on the online mysql
server from the command line it works but not thru php3 online.
Take a look at vvmm.net
TIA
Adrian
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php