note 67252 added to class.com

i try to count record from MSSQL 2000 database table i use this command.... <?php ... $total = $conn->Execute("SELECT COUNT(id) as num FROM sometable"); $total_result = $total->Fields->Count(); echo $total_result; ... ?> its always result 1 even there is more than 1 records in the table.... please help me... ---- Server IP: 202.158.56.242 Probable Submitter: 222.124.25.38 (proxied: 1.1 SATELIT1, 1.0 CACHE1) ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/class.com.php Edit -- http://master.php.net/note/edit/67252 Del: integrated -- http://master.php.net/note/delete/67252/integrated Del: useless -- http://master.php.net/note/delete/67252/useless Del: bad code -- http://master.php.net/note/delete/67252/bad+code Del: spam -- http://master.php.net/note/delete/67252/spam Del: non-english -- http://master.php.net/note/delete/67252/non-english Del: in docs -- http://master.php.net/note/delete/67252/in+docs Del: other reasons-- http://master.php.net/note/delete/67252 Reject -- http://master.php.net/note/reject/67252 Search -- http://master.php.net/manage/user-notes.php