Mikey wrote:
bruce wrote:
hi...
if an app has a webpage that has to interface/display data from a
mysql db,
does the app have to essentially do a new db_connection for each time
that a
user accesses the page during the session.
as far as i can tell, it does.
in other words, the page would need to look something like:
<?
start the page
do the db_connect
do the db_query
process the information from the db/tbl
close the db_connection
?>
the only reason i ask is that it would be nice/good if there was some
way of
opening a connetion once for a given session (save bandwidth) as well as
somehow saving data from the db/tbl (short of using session vars)
thanks
-bruce
bedouglas@xxxxxxxxxxxxx
What you should use is a persistent connection - mysql_pconnect() - IIRC
HTH,
Mikey
Ooops, forgot the second part of your question - if you want to save the
data from a query then you will have to use session vars, although only
do this with data that you know will not change during the lifetime of a
user session.
Mikey
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
