[RESOLVED] Accurate MySQL Query Counting

[PHP_Novice2]

I've set up a query counter that iterates whenever mysql_query is called. Are mysql_fetch_array and mysql_num_rows also technically queries, or is the initial DB call the only one that counts?

[bpat1434]

I believe it is mysql_query() that is the only database attached item. Everything else relies upon the resource returned from mysql_query().

😉

[PHP_Novice2]

bpat1434 wrote:

I believe it is mysql_query() that is the only database attached item. Everything else relies upon the resource returned from mysql_query().

😉

So if I do the following:

$sql = "SELECT * FROM table";
$query = $db->doQuery($sql);

$numRows = mysql_num_rows($query);
$row = mysql_fetch_array($query);

Only 1 query is being executed?

[bpat1434]

Yes.... only one query...