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

Reply via email to