Number of Rows Returned by query in php

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>

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : Number of Rows Returned by query in php
convert integer number to octal,hexadecimal number systems -
convert octal number to decimal number -
convert decimal number to octal number -
three rows frameset . -
Select odd rows from table -
Get affected rows for an update in php -
delete duplicate rows in mysql using php -
Multi colored table rows -
Listing All Rows and Fields in a Table -
different colors for table Even- Odd rows and Cells -

Topic Tags

PHP Database

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.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