count entries in mysql table

[schismdesign.nl]

hi there everyone,,,

im kinda a noob to programing, and couldn't find any tutorials on this matter anywhere...

i am making a petition website with php and mysql database...

i simply want to know how i can count the number of entries in the mysql table...

e.g.

so i can echo on the page the number of people who filled in the petition.

if someone could help me with this,

i ll be eternally grateful

 

thanks

 

chris

[jitesh]

$result = mysql_query("SELECT COUNT(*)  AS TotRecords FROM `Table`");

echo mysql_result($result,0,'TotRecords');

[vbnullchar]

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

?> 

[schismdesign.nl]

thanks a lot guys!