Hm, I think that the question was whether multiple visits on a database-driven site would be handled well, because each php page, which requires data from the db, would initiate a new sql session as well in order to insert, update or retrieve.
The solution is called persistent link and PHP supports it.
Here is some information on it.
http://bg2.php.net/mysql_pconnect
http://bg2.php.net/manual/en/feature...onnections.php
In theory this would minimize number of connections, however there are discussions whether this method is secure or not.
Also, many host service providers do not allow using persistent connections due to being afraid because of uncertainties how this method may be exploited by malicious users.
If I am not mistaking though, if you use includes for mysql authentication, and you do not close the connection on each querry, only one connection per session is created. In general, a user browsing your website will have 1 connection during his browsing session, until his session expires, or he closes his browser.
As for the ORM's I am not 100% sure they will minimize connection to database, unless they serve as some kind of middle-level mediator between the front end and the database. E.g. you can have multiple requests to the ORM from an on-line application, which are synthesized to a single connection from the ORM to the database. I have to read on the ORM's though...