Page 1 of 1

mysql_num_rows error when database empty

Posted: Tue Dec 30, 2003 4:49 am
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



?>

Posted: Tue Dec 30, 2003 5:48 am
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?