WELCOME TO OUR FLOWER DATABASE As you could imagine, we have quite a lot of flowers to show you. Hundreds in fact, each with a number of varieties. So we've put them all into a database through which you can browse. Simply enter information in one or more of the fields below to list the appropriate flowers, then click again to get the detail of a single flower type. Category of Flowers <% Response.Write("All Categories ") SQL = "SELECT * FROM category ORDER BY categoryname" set rs_category = dbconn.Execute(SQL) while not rs_category.EOF Response.Write(""&rs_category("categoryname")&" ") rs_category.MoveNext Wend rs_category = null %> Common Name Botanical Name Colour Month of Availability Start Finish All Months  January  February  March  April  May  June  July  August  September  October  November  December  All Months  January  February  March  April  May  June  July  August  September  October  November  December  © Copyright 2002 The Australian Flower Company. All rights reserved.