Multiple Queries?

[Reformed]

I'm trying to display a page that requires one db query to fetch all of the records from a database and display them. On this same page I'm going to allow users to insert new records.

To insert a new record I've supplied some text areas for unique information and 4 dropdown selects for know information. I want the dropdowns to display information from my database, but in order to do this it looks like I'll need a query for each of the 4 dropdown selects because each of the dropdowns will display db information from a different table.

Anyone know of a better way to do this? 5 db queries sounds like way too much to me, but with the information in 4 different tables for 4 different dropdowns, I can't think of another way.

[eoghain]

That is the only way you can do it. And 5 queries isn't as many as you think it is.

Take a look at many of those news sites they do way more than 5 queries for each page.

[Reformed]

Thanks for the reasurance. I just don't have anything to measure against because I've never had to do so many queries in one script. I set it up and it's not so bad.😃