thanks.. but
PHP:--------------------------------------------------------------------------------
$db = //db connection

$sql = mysql_query("SELECT * FROM table", $db);
$rows = mysql_num_rows($sql);

//echo $rows;

perhaps it works.....

mysql_num_rows kite bleh dapatkan jumlah rekod atau bil rekod yg affect ngan query?

apa beza ngan "select count(nama medan) from nama table";
thanks so much!!!

refards