it's working now. Thanks Oson --- "Oson, Chris M." <[EMAIL PROTECTED]> > wrote: >try: > >$strSQL = "SELECT COUNT(*) AS 'ItemCount' FROM my_table"; >$result = mysql_query($strSQL, $db); >list($numberOfItems) = mysql_fetch_array($result); > >echo "The number of items in the database is: $numberOfItems\n"; > >hTH > >-----Original Message----- >From: Naga Sean [mailto:[EMAIL PROTECTED]] >Sent: Friday, March 30, 2001 11:59 AM >To: [EMAIL PROTECTED] >Subject: [PHP-DB] 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 <[EMAIL PROTECTED]> > >> 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: [EMAIL PROTECTED] > >>>For additional commands, e-mail: [EMAIL PROTECTED] > >>>To contact the list administrators, e-mail: [EMAIL PROTECTED] > >> > >> > >> > >>-- > >>PHP Database Mailing List (http://www.php.net/) > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >>To contact the list administrators, e-mail: [EMAIL PROTECTED] > >_____________________________________________________________ >www.kaskus.com - FREE EMAIL SERVICE > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] _____________________________________________________________ www.kaskus.com - FREE EMAIL SERVICE -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]