[SOLVED] adding mysql_num_rows

[Zeradin]

I have this

				$newitemquery = 'SELECT * FROM reviews WHERE visible = 0';
			$newitemresult = mysql_query($newitemquery);
$newitemquery2 = 'SELECT * FROM articles WHERE visible = 0';
			$newitemresult2 = mysql_query($newitemquery2);
			if (mysql_num_rows($newitemresult) > 0) {
			echo '<a href="approve.php?atyp=item" target="formload"><strong>Approve/Hide Items ['.mysql_num_rows($newitemresult).' New]</a></strong>';

 

and i want to add the mysql_num_rows from newitemresult and newitemresult2

what's the best way to do that?

[fenway]

First, if you're only going to be counting the rows, NEVER use SELECT * -- use SELECT COUNT(*)!

 

Second, why not simply do this:

 

SELECT ( SELECT COUNT(*) FROM reviews WHERE visible = 0  ) + ( SELECT COUNT(*) FROM articles WHERE visible = 0  ) AS itemCount

[Zeradin]

because i'm not very good at sql yet=)

thanks