Count record from SQL 2000 Table

[predhtz]

i use this code to count total record like total member from SQL 2000, but didn't work properly.... can someone help me?

<? $rs=$conn->Execute("SELECT * FROM member");
$num_columns1 = $rs->Fields->Count();
if (!$rs3->eof){
for ($i=0; $i < $num_columns1; $i++){
echo "$num_columns1";
}
$rs3->MoveNext();
}
?>

[Weedpacket]

And, what do you mean "it didn't work properly"? Did it just spend all day chatting up the secretarial staff?

What's with $rs and $rs3? Why do you repeat echoing the same value ($num_colums1) $num_columns1 times? Why is the $rs3->MoveNext() method outside the loop, or do you only want to look at one record? Why don't you just use "select count(*) from member" and get the total record count directly?