mscreashuns — Mon, 25 Jul 2005 23:02:00 +0000

Or, if you want a 1 character longer code...

<?php
 
$query = \"SELECT COUNT(*) FROM alumni WHERE state='NJ'\"; 
                        $result = mysql_query( $query ); 
                        $totalEntries = mysql_result( $result, 0 ); 
if ($totalentries >= \"1\") {
                        print \"<p>\".$totalEntries.\"</p>\n\"; 
}
 
?>

and like Greg K. said, you could add an else statement to be displayed if there are 0 results, like this.

<?php
 
$query = \"SELECT COUNT(*) FROM alumni WHERE state='NJ'\"; 
                        $result = mysql_query( $query ); 
                        $totalEntries = mysql_result( $result, 0 ); 
if ($totalentries >= \"1\") {
                        print \"<p>\".$totalEntries.\"</p>\n\"; 
} else {
print \"<p>There were no entries found.</p>\n\";
}
 
?>

Greg K — Wed, 20 Jul 2005 06:40:24 +0000

<?php
if ($totalEntries > 0) print \"<p>\".$totalEntries.\"</p>\n\";
?>

More advanced for if you need soemthing else:

<?php
if ($totalEntries > 0)
 {
    print \"<p>\".$totalEntries.\"</p>\n\";
 }
 else
 {
    // do something else here
 }
?>