CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 MySQL random sort

Print topic Send  topic

Author Message
Rick Page
Posted: 04/26/2003, 9:03 PM

I'm using php and MySQL. I am also using the "order by rand()" to get a random sort. The problem I'm having is with having more records than what will fit on one page. First, the reason I want to do random sort is so that the same records don't always show up on the first page. These records are musicians and I would like to give everyone a chance to show up on the first page. Anyway, when I do the random sort, everytime the visitor clicks on the next or previous links to show the other records, they get a new random sort of records instead of seeing the rest of the records. Any suggestions?
morph
Posted: 04/27/2003, 6:27 AM

Ristrict the number of records shown by selectiing form properties and then set the number of records shown in page navigation

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.