query for # results only

[BEFOR]

I'm doing a query to echo the # of total results.

There is a three way inner join/select max being used.

Anyway, how or even should I integrate the # results with the query.

That's all that is being returned.

There will be over fifty queries on the page (a reports page) covering regions of the United States. The values are constantly changing.

count / num rows?

[Fernashes]

The MySQL count function should do the trick...

[BEFOR]

It did, as long as I have the GROUP BY NULL.

• Am trying to figure, why my query won't detect a value:

ex: <?php if ($category='50'){echo $row_X['COUNT(*)'];}?>

$category is defined as a varaible in the query.

Is there something wrong with this simple statement here?

Can the variable be detected from within the cell or does each of the outcomes have to be inside the SELECT query itself? If so, how would it be done?