[SOLVED] echo problem

[ballhogjoni]

I am trying to echo "There are no leads" because there are no records in my db. How do I get this to work correctly?

 

$sql = mysql_query("SELECT * FROM dispo_money LIMIT $from, $max_results");
	while($row = mysql_fetch_array($sql)) {		
		// Figure out the total number of results in DB: 
		$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM dispo_money"),0); 
		// Figure out the total number of pages. Always round up using ceil() 
		$total_pages = ceil($total_results / $max_results);
		if ($total_results == NULL) {
			echo "There are no leads";
		}

[taith]

$sql = mysql_query("SELECT * FROM dispo_money LIMIT $from, $max_results");
if(mysql_num_rows($sql)==0){
echo 'empty!';
}else{
while($row = mysql_fetch_array($sql)) {		
}
}