Hi there!!

I've got a web site programmed in ASP connecting to a mySQL database. The
front page of the web site performs 10 seperate searches on the database and
from what I can see, Dreamweaver programmes it so that it opens 10 different
connections to the MySQL server. The only problem I have with this is that
my host only allows me to have 20 connections to the server as a maximum, so
the instant I get more that two people on the site at any one time, it
instantly falls over.

Is there anyway to get Dreamweaver to only open up one connection to the
database, perform all the searches with this one connection and then close
it when it has finished with it?

I hope some one can help as I'm getting desperate as the web site is being
severly restricted.

Kind Regards

Sean
DVD Web Editor
www.dvdweb.co.uk