var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: could this code make a load??
the number or rows about 4000 each table
$resultfiles = mysql_query("SELECT * FROM file");
$num_rowsfiles = mysql_num_rows($resultfiles);
echo "$num_rowsfiles Files\n & \n";
$resultmirrors = mysql_query("SELECT * FROM mirror");
$num_rowsmirrors = mysql_num_rows($resultmirrors);
echo "$num_rowsmirrors Mirrors\n";
Why don't you use count(*) if all you want to know is the number of rows?
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?
Why? What's preventing you to change the queries?
Originally Posted by hscorp
i just don't know how to do it
To get the count of all rows in a table use:
More details in the manual:
select count(*) from the_table
]MySQL :: MySQL 5.0 Reference Manual :: 12.2.8 SELECT Syntax