Re: Random Row From Database

How is this -dev? How is it php? This is crossposted. -AZ "Hew Staff" <hewweb@hardiman-e-worldwide.com> wrote in message news:20011111041949.71334.qmail@pb1.pair.com... > Hi, > > I'm trying to pull a random row from my database and display the contents. > > I know that the code: > SELECT * FROM TABLENAME WHERE RAND() LIMIT 1 > should work. > > However, there are 19 rows in the database and only the first row ever shows > up. > > Is there a way to do this to ensure uniqueness? > > The code I am using at the moment also filters so that rows are pulled from > the database given certain other criteria such as: > > SELECT * FROM TABLENAME WHERE PayerID=$id AND RAND() LIMIT 1 > > All of the rows in the database contain the same PayerID and this column is > not the Primary Key. > > Any help much appreciated. > Jonathan S Hardiman > President/CEO > Hardiman Enterprises Worldwide > >