How to populate a HTML DropDown box Icon

How to populate a HTML DropDown box

Our example below uses a table 'tblFriends' in an Access database 'Friends.mdb'.

How to populate a HTML DropDown boxOverview

Our example below uses a table 'tblFriends' in an Access database 'Friends.mdb'.

Our example below uses a table 'tblFriends' in an Access database 'Friends.mdb'. The table has 3 columns, firstly an 'ID' field which is an autonumber, secondly a field called 'FirstName' which is a textfield and lastly another textfield called 'SurName'.

Our SQL statement uses the wildcard % and looks for those records where the FirstName's first letter begins with a T and populates the drop down with the records returned. If the form has not been submitted then the dropdown list will be displayed and if it is submitted then the selected option will be displayed.

If there are no records that begin with the T (i.e. If oRecordset.Eof) then the drop down Box will show "No Suitable Options" and if submitted the page will display "No suitable option was selected."

NEW

Fixed some bugs.

How to populate a HTML DropDown boxInformation

Version
N/A
Date
07.30.10
License
Free
Language
English
File Size
N/A
Developer
Category
SubCategory
Operating Systems
Windows
System Requirements
No additional system requirements.
MiniClip Games Icon
Updated to work with safemode=on I found several little flash games
Free
Pro Arcade Script Icon
Build a nice-looking, profitable flash gaming website in 1 hour
Paid
ECG simulation using MATLAB Icon
ECG simulation using MATLAB generates all possible forms of ECG signals with the
Free
HYIP Monitor Script Icon
This HYIP Monitor script uses a database to store information.
Paid
DPX file reader Icon
A DPX file parser .
Free
JobFlexer - Job Board PHP Script Icon
JobFlexer is your friend in career and in employment business
Trial
cPanel/WHM Account Creator for Reseller Icon
Create user account in cPanel/WHM, create subdomain in WHM,etc.
Free
TagCloud-a-like script Icon
Configure Tag-cloud script that will randomize the display of your links.
Free
More