hi guys,

hope someone could point me to the right direction here. i've been doing this project for one of my dad's clients, using php. the web admin said that the queries i placed in the page (i crammed everything into 1 page) said the queries in the page have been clogging up the site because i haven't been closing my sql queries/connections (i just took a crash course in php with a book i bought, so i'm not familiar with good coding practices in PHP).

so my questions are:
1. do i just place my mysql_close commands at the end of my php scripts or do i have to put it after every query?

2. is there a way (tool) that i can check/use to see how much clogged the site is and if closing the database connections i'm about to put are working?

also, to save in constant coding, i like to have either a class or a include file with all the data base log in, and just either link to the class, or include the file, which saves time on all the remaining pages i code.

i am unsure of any tools off hand, except the ones your web server should already have. if you log into your server's administration panel, there should be a way to look at your bandwidth usage.