Start PHP with us. Includes topics to help you in phpNumber of Rows Returned by query in php
Sun Oct 26, 2008 7:27 pm
Number of rows returned by query in php
- Code:
<html>
<head>
<title>Using mysql_num_rows()</title>
</head>
<body>
<?php
$user = "user";
$pass = "password";
$db = "userdb";
$link = mysql_connect( "server", $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>
Topic Tags
PHP DatabaseCodemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com
Powered by phpBB © phpBB Group.