اخي daif لو ممكن التطبيق على الكود
الكود كامل
كود PHP:
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="t1"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT DISTINCT c1 FROM t1";
$result=mysql_query($sql);
$num= mysql_num_rows($result);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link type="text/css" href="1.css" rel="stylesheet" media="screen" />
<title>a</title>
<link rel="shortcut icon" href="http://monorom.com/favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<div id="container">
<div id="left">
<p>
<div align="left"><img border="0" src="style/images/left.jpg"></div></p>
</div>
<div id="content">
<h2>Processing Data .....</h2>
<br> <br>
<h4><b>table 1 .....</b></h4>
<p><b>first file click here
<?php $num = mysql_num_rows($result);
echo $num; ?></p>
</div>
</body>
</html>