2 questions here

[Clive]

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

[filburt1]

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.

[Clive]

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)

[filburt1]

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

[Clive]

nice. So how can I count the queries executed?

[Gary King]

Maybe have a function like this:

PHP Code:

function query($query)
{
    global $querycount;
    
    $sendquery=mysql_query($query);
    if ($sendquery)
    {
        $querycount++;
    }
} 


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

[Clive]

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