is mysql_close not needed in access_user_class?

Hi - I am using your user class which I have found very useful.

However I was just wondering if mysql results connections need to be closed with:

mysql_free_result();
mysql_close();

Is a new connection made each time - just wondering if this is extra unnecessary overhead?

Thanks,
fergal

[Join us @ facebook]

php automatically closes the connections when a script ends execution.

thanks for the speedy response. So what are mysql_free_result and mysql_close used for then? and why have I been using them in my code up to this.

Thanks again,
Fergal

[Join us @ facebook]

Well they just decrease the overhead by a bit, because if for example you do some queries and then do some other stuff that don't need the database connection, then you can close it so the server will have more resources available.

BTW welcome to webdigity fergalfrog

... if you use the php function mysql_pconnect you need to close the connection.

use mysql_free_result if you have big result sets

Cool thanks for the answers guys....

I get this error:

Warning: mysql_connect() [function.mysql-connect]: User **** has already more than 'max_user_connections' active connections in /****/****/****/httpd.www/classes/access_user/access_user_class.php on line 135

I'm not opening more connections myself somewhere. The startpage displays no errors. after browsing a couple of links at my site the error appears (at the startpage aswell if you go to 'hom').
Can i close the connection somewhere ?

I get this error:

Warning: mysql_connect() [function.mysql-connect]: User **** has already more than 'max_user_connections' active connections in /****/****/****/httpd.www/classes/access_user/access_user_class.php on line 135

I'm not opening more connections myself somewhere. The startpage displays no errors. after browsing a couple of links at my site the error appears (at the startpage aswell if you go to 'hom').
Can i close the connection somewhere ?

ask your provider to fix this problem

Ok, if the problem keeps occuring again i ask them to look into it. Thanks for your reply olaf.

By the way, I got my website up and running pretty nicely now. If anyone wants to know how to use access_user class with 1 file (index.php) where different sections get included instead of static pages give me a shout

[Guest]

[62.870]

Googlebot