Re: Database

Glover George wrote: > > There's no way to store this in another table because of the nature of the > program. It reads every table out of the database and constructs a drop > down list (actuall, a list of companies) from the tables so I wouldn't want > it showing the table I am storing this info in. So I would basically have > to create a second database, but that's way too much overhead as I'd be > making too many connections. An easy way to create Option Lists (pulldowns) and Input Lists (radio and check boxes) from dynamic content in your database is using my SQL Solution class. Here are direct links to the section of the manual where these two functions are explained: http://www.analysisandsolutions.com/code/sql/sql-man.htm#OptionListGenerator http://www.analysisandsolutions.com/code/sql/sql-man.htm#InputListGenerator Enjoy, --Dan -- PHP scripts that make your job easier http://www.analysisandsolutions.com/code/ SQL Solution | Layout Solution | Form Solution T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Ave, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409