mysql_num_rows error when database empty

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
lazerbri
Forum Newbie
Posts: 15
Joined: Sat Dec 27, 2003 8:17 am

mysql_num_rows error when database empty

Post by lazerbri »

mysql_num_rows error when database empty

do you know how to get round this other then always having one member in a database.

Code: Select all

Make_the_connection_to_my_sql($host, $dbusername, $dbpasswd);
$rs = mysql_select_db($database, $conn) ;
	$sql = "select * from members";
	#Execute query
	$rs = mysql_query($sql, $conn);
$num_rows = mysql_num_rows($rs) ;

<?php



?>
User avatar
AVATAr
Forum Regular
Posts: 524
Joined: Tue Jul 16, 2002 4:19 pm
Location: Uruguay -- Montevideo
Contact:

Post by AVATAr »

Do you want to count how many members are in the DB?

you can use a sql statement: 'select count(*) from members'

What's the error?
Post Reply