Just noticed that this is article number 100000 on the BlogEasy site. What's the chance of writing an article and then getting this number. I wonder if they are giving out prizes for this.
Here are a few ways to select a random row from a database table. These SQL statements won't require any additional application logic to pull the information you need.
Select a random row with MySQL:
SELECT column FROM table ORDER BY RAND() LIMIT 1
Select a random row with PostgreSQL:
SELECT column FROM table ORDER BY RANDOM() LIMIT 1
Select a random row with Microsoft SQL Server:
SELECT TOP 1 column FROM table ORDER BY NEWID()
Select a random row with IBM DB2:
SELECT column FROM table ORDER BY RAND() FETCH FIRST 1 ROWS ONLY
Select a random record with Oracle:
SELECT column FROM ( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum = 1
Here is a great link to find all the available FireFox extensions in one place. It is very useful. Here is a really good extension for instantly displaying the Google PageRank and Alexa ranking for every site you visit.
Here is a link to another cool FireFox extension that allows you to block those annoying Shockwave Flash advertisements.
Just found a pretty cool site to help out with web development. You can create banners with text at http://header.portal.aau.dk instantly.
Here are some good resources for using web design patterns when creating user interfaces.
An Introduction to Using Patterns in Web Design
Web Design Patterns
FireFox and Mozilla browsers have some great plug-ins for web developers. Check out this plug-in for web developers. It is very useful.