Hey i made this code to read cnstats information for me.
Here it is:

<?php
mysql_connect("localhost", "main_cnstats", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());

$result = mysql_query("SELECT hits,hosts FROM cns_counter") 
or die(mysql_error()); 

while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row
echo "<b>Todays Visitors:</b> ".$row['hosts']. "<br><b>Todays Hits:</b> ".$row['hits']. "<br>";
} 
?>

But when i put it in on my website, when i go to look at the games on my website i get the error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/main/public_html/v2/includes/browse.php on line 64

This is like 64 of browse.php and a line above and bellow it:

$numresults = mysql_query($sql_query); // the query.
$numrows = mysql_num_rows($numresults); // Number of rows returned from above query.
if ($numrows == 0){

That error means the SQL query failed. Add an or die(mysql_error()) to that query on line 63, that way when it fails you see the MySQL error telling you what went wrong instead of the PHP error that tells you that 'something went wrong but I won't tell you what'.

ok, did that now i get the error:

Parse error: parse error, unexpected T_LOGICAL_OR in /home/main/public_html/v2/includes/browse.php on line 63

But on 63 i put

or die(mysql_error())

What I meant was that your query should look like this:

PHP Code:

$numresults = mysql_query($sql_query) or die(mysql_error()); 


now the error is:

Table 'main_cnstats.games' doesn't exist

But the table aint even called that its called.
main_cnstats

As it says in the connect info. why it think .games should be on the back of it? .. makeing no sence.

What is in $sql_query when the query is executed? I'm guessing you have something like

SELECT * FROM main_cnstats.games

when it should be

SELECT games from main_cnstats

check your $sql_query variable has the right stuff in it.