2 questions here
 

1) how do I count queries executed? I heard I had to use class on it but I dunno how, could someone please give me a sample code for it?

2) I had one mysql_query(); code on my script, and 4 mysql_result(); code on it. How many queries did the script executed? I mean, is the mysql_result(); function counted as a query?

thanks

Each call to mysql_query() generates one query (so $DB_site->query() and $DB_site->query_first() each generate one query).

Only if this is a testvb, add $debug=1 to config.php, then tack &explain=1 onto the URL of the page you want to check.

If it's your own page, either use the included DB_mysql.php file and its DB_site class, or write your own wrapper one.

errr, tis has nothing to do with vb :( I'm making my own script, I had too many mysql_results(); on my script and I wanna know if it will slow down the server load. (I wanna know how many queries did the script executed too)

mysql_result() doesn't use any more queries or significantly increase server load.

nice. So how can I count the queries executed?

Maybe have a function like this:

And use query instead of mysql_query. It will add 1 to $querycount everytime you use a query :)

and I'll just echo $querycount out? thanks!