|
<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>
|
