Confuse w/ count function?

I try to use this count function, but no matter how. I got this result from $t = Resource id #4 $t = mysql_query("SELECT COUNT(*) FROM my_table",$db); echo($t); any comments ? -naga --- Andrei Skorokhod <skorokh1@msu.edu> > wrote: >if you just need the number > >SELECT COUNT(*) FROM table where ................ > >At 06:34 PM 3/30/2001 +0100, DC wrote: >>Hi All >>I cant quite work out how to count the number of rows in my mysql db that >>match a certain critieria and the show that number numericaly in my pages. >> >>Checked books, php.net etc. >> >>Any help is appreciated >> >>Yours Dave C >> >> >> >>-- >>PHP Database Mailing List (http://www.php.net/) >>To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >>For additional commands, e-mail: php-db-help@lists.php.net >>To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net _____________________________________________________________ www.kaskus.com - FREE EMAIL SERVICE