yolop Posted July 4, 2010 Share Posted July 4, 2010 i saw in my server this .... 874751 da_eee localhost da_eee 5 Sleep 874748 da_eee localhost da_eee 6 Sleep 874749 da_eee localhost da_eee 6 Sleep 874743 da_eee localhost da_eee 7 Sleep 874745 da_eee localhost da_eee 7 Sleep 874738 da_eee localhost da_eee 8 Sleep 874740 da_eee localhost da_eee 8 Sleep 874735 da_eee localhost da_eee 9 Sleep 874736 da_eee localhost da_eee 9 Sleep 874731 da_eee localhost da_eee 10 Sleep 874732 da_eee localhost da_eee 10 Sleep 874733 da_eee localhost da_eee 10 Sleep 874734 da_eee localhost da_eee 10 Sleep 874725 da_eee localhost da_eee 11 Sleep 874727 da_eee localhost da_eee 11 Sleep 874728 da_eee localhost da_eee 11 Sleep 874730 da_eee localhost da_eee 11 Sleep 874713 da_eee localhost da_eee 15 Sleep the admin of the server say that every query open the databace and dont close him and that fall the server what i need to do thank Link to comment https://forums.phpfreaks.com/topic/206703-unclose-query-in-my-system/ Share on other sites More sharing options...
kenrbnsn Posted July 4, 2010 Share Posted July 4, 2010 Please post your code. Ken Link to comment https://forums.phpfreaks.com/topic/206703-unclose-query-in-my-system/#findComment-1081022 Share on other sites More sharing options...
mattal999 Posted July 4, 2010 Share Posted July 4, 2010 Effectively after every script that connects to mysql, you need to use mysql_close(). This closes the connection with MySQL and frees up one connection space. Link to comment https://forums.phpfreaks.com/topic/206703-unclose-query-in-my-system/#findComment-1081060 Share on other sites More sharing options...
Mchl Posted July 4, 2010 Share Posted July 4, 2010 Effectively after every script that connects to mysql, you need to use mysql_close(). This closes the connection with MySQL and frees up one connection space. PHP does this for you (unless you're using persistent connections). Link to comment https://forums.phpfreaks.com/topic/206703-unclose-query-in-my-system/#findComment-1081073 Share on other sites More sharing options...
yolop Posted July 4, 2010 Author Share Posted July 4, 2010 Effectively after every script that connects to mysql, you need to use mysql_close(). This closes the connection with MySQL and frees up one connection space. PHP does this for you (unless you're using persistent connections). Effectively after every script that connects to mysql, you need to use mysql_close(). This closes the connection with MySQL and frees up one connection space. in the end of every page i will need to do mysql_close()??? Effectively after every script that connects to mysql, you need to use mysql_close(). This closes the connection with MySQL and frees up one connection space. Effectively after every script that connects to mysql, you need to use mysql_close(). This closes the connection with MySQL and frees up one connection space. PHP does this for you (unless you're using persistent connections). how will i konw if php do this for me? Effectively after every script that connects to mysql, you need to use mysql_close(). This closes the connection with MySQL and frees up one connection space. in the end of every page i will need to do mysql_close()??? PHP does this for you (unless you're using persistent connections). Link to comment https://forums.phpfreaks.com/topic/206703-unclose-query-in-my-system/#findComment-1081102 Share on other sites More sharing options...
Mchl Posted July 5, 2010 Share Posted July 5, 2010 No. You will need to show us some of your code, so that we can see what is the problem. Link to comment https://forums.phpfreaks.com/topic/206703-unclose-query-in-my-system/#findComment-1081217 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.