could this code make a load??

hscorp · #1 (**permalink**) 03-20-09, 20:31

PHP Code:


			
<?

                    

                    require 'includes/db.inc.php';

                    

                    $resultfiles = mysql_query("SELECT * FROM file");

                    $num_rowsfiles = mysql_num_rows($resultfiles);

                    

                    echo "$num_rowsfiles Files\n &amp; \n"; 

                    

                    $resultmirrors = mysql_query("SELECT * FROM mirror");

                    $num_rowsmirrors = mysql_num_rows($resultmirrors);

                    

                    echo "$num_rowsmirrors Mirrors\n";

                    

                    ?>

the number or rows about 4000 each table

shammat · #2 (**permalink**) 03-20-09, 20:37

Why don't you use count(*) if all you want to know is the number of rows?

hscorp · #3 (**permalink**) 03-20-09, 20:40

I'm not experienced in db stuff so i couldn't make it with count(*)

but the problem not how to make it the problem is that the host company suspended my site because of a page just contain this code no more queries in this page so i wonder could this be the cause?