Randomize results?

[tequilacat]

I'm using mySQL with php to query a database and bring up results by zip code. Is there a way that I can make the results come up randomly every time? As it is now, my results are coming up in the same order every time.

FYI, here's the site: http://www.petsitaustin.com

try 78759 for the zip code...it's these results I'd like to come up randomly.

thanks,
Therese

[volleytotal_ch]

add this to your sql-command:

.. ORDER BY rand()

[tequilacat]

Thanks! That was much easier than I'd expected 🙂 I do have a question though. I added the bit of code but when I tried it, although my list did come up randomly, one of the results almost always came up at the end, and there were two that seemed to almost always come up at the top of the list. Was this probably just coincidence or is there another reason?

Thanks again!