Welcome to my ASP Code Website

Fortune Cookie / Random Quote Code - Database



It's always fun to have a fortune cookie on your website, to give a random quote or fortune or message each time the visitor comes by. Note that this version requires a database to work.

First, you need a database with the quotes or fortunes or whatever you will be showing. Create a database table, fortunes, with two columns - the item_id and the item_desc. The item_id would be a running series of numbers such as 1, 2, 3, 4, and so on. The item_desc would be the actual fortune or quote. So it could be "beware of short men" or "the cat will bring you good luck" or any other quote you decide on.

The benefit of this method is that you can create as many rows as you could possibly desire, and the code never changes. The new rows automatically get added into your mix.

You now need to figure out how many rows are in the database to know what range to choose a random number in. How to use the SQL Max Function. That will give you MaxID.

Next, use this MaxID to come up with a random number between 1 and that top ID number. How to use the Randomize Function. Your randomize function would be:

CurrID = Int((MaxID * Rnd) + 1)

Now you have an ID number somewhere between 1 and the maximum ID in your database. Now all you have to do is select the matching phrase!

select item_desc from fortunes where item_id = CurrID;

That's it! Now you can show your item_desc to your user and have different fortunes, quotes, phrases or anything else appear each time they come back!

Fortune Cookie Code Using an Array
ASP Free Game Code