<html> <head> <title>Using mysql_num_rows()</title> </head> <body> <?php $user = "navioo"; $pass = "password"; $db = "navioo"; $link = mysql_connect( "mysql153.secureserver.net", $user, $pass );
if ( ! $link ) { die( "Couldn't connect to MySQL" ); }
mysql_select_db( $db, $link ) or die ( "Couldn't open $db: ".mysql_error() ); $result = mysql_query( "SELECT * FROM Employee" ); $num_rows = mysql_num_rows( $result );
print "There are currently $num_rows rows in the table<P>"; mysql_close( $link ); ?> </body> </html>
|