Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › random products listing

View all replies to this thread

random products listing

Thread began 1/04/2010 10:03 am by muddysmurf | Last modified 1/04/2010 4:16 pm by muddysmurf | 1237 views | 1 replies

1/04/2010 10:03 ammuddysmurf

random products listing

What's the best way to go about randomizing a section on my website of products.. kinda like what Amazon has, "Other items you may be interested in" but pull it from the same category the customer is viewing from. I don't want to use Order By Rand() because the database will be large..and you really can't pick it by category I don't believe.

Also, say I'm listing my content as below on my website.

Name of Item
Author
Description
Price

and the current product doesn't have a description, how do I get the Price section to move up instead of having white space showing like this:

Name of Item
Author

Price

Thanks!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.