RE: [PHP]Getting rows in a db...

Bear in mind that you don't want to be doing queries like that generally. Use count(*) to get the number of rows - using mysql_num_rows is slower. eg $query="select count(*) from tablename where cat='band'"; $result = mysql_query($query,$conn); etc. -----Original Message----- From: David Robley [mailto:huntsman@www.nisu.flinders.edu.au] Sent: August 2, 2001 2:13 PM To: Chris Cocuzzo; php-general@lists.php.net Subject: Re: [PHP]Getting rows in a db... On Thu, 2 Aug 2001 14:57, Chris Cocuzzo wrote: > hey- > > if I do this: > > $query = "SELECT user FROM table WHERE cat='band'"; > $result = mysql_query($query,$conn); > $rows = mysql_num_rows($result); > > will I get something back from the $rows variable, or am I using the > mysql_num_rows() function incorrectly. What I'm trying to do is get the > number of rows returned as a result of that specific sql statement and > query. > > thanks > chris That should show the number of rows returned by the query, providing there is a successful result. Try it! -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Shotgun wedding: a case of wife or death. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net