counts rows

[mohamad_1978]

Hi
is there code to count how many rows in the db i have
for example if i made database called (school)
and i have table ( student)
and i wana to know how many students i have in this table
i know i can use while but is there way to do it with less trafic to my db if i have 10000 rows

another thing
if i have in the table stundents the field (grade)
i wana to count the average os these grades

AV grade = adds of the grads / num of students

can i get the adds of grads in easy way without use while loop ?

[aviendha]

To get number of rows I've used:

$query = "SELECT field FROM table";
$result = mysql_query($query) or die("Couldn't execute the query");
$rows = mysql_num_rows($result);

[robogenus]

Try using the php function 'mysql_num_rows'.

example:

$select = "select * from student";
$result = mysql_query($select);
$num_students = mysql_num_rows($result);

this will give you the number of students.

for mysql mathematical functions to get average grade
check out:

mysql documentation section 6.3.3.2 Mathematical Functions

at www.mysql.com or

click here:
http://www.mysql.com/doc/en/Mathematical_functions.html

robogenus