PHP回傳結果集的紀錄筆數

mysql_num_rows(’查詢字串’, 連線識別元)

$link=mysql_connect('localhost','root','123');

$db_selected=mysql_select_db(‘payments’,$link);

$sql = mysql_query("SELECT * FROM `payments` WHERE txnid = '$tnxid'", $link);

$num_rows=mysql_num_rows($result);