The error is in the line marked red can u tell me what is the error?


<?php
$link= mysql_connect('localhost','xxxxx','xxxxx');
@mysql_select_db('xxxxx','xxxxx','xxxxx',$link);
$query="SELECT * FROM table WHERE lname LIKE 'M%' ";
$result=mysql_query($query,$link);
$num=mysql_num_rows($result);
?>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"fname");
$f2=mysql_result($result,$i,"lname");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
</tr>

<?php
$i++;
}
mysql_close();
?>

The issue is not with mysql_num_rows() although I'm sure the error you're receiving says it is. The issue is with your mysql query not returning any results for mysql_num_rows() to work with. The error can be with your mysql query. It is best to firstly test your query in either a terminal(linux) or command prompt(windows) or phpmyadmin.

Since the structure of the sql is correct it's not a mysql issue either. So if your query runs(phpmyadmin or command-line verified) then the issue may be with your connection iformation.

Silver-based jewelry, toilet table sets and presents have attracted customers right away due to the designs and also , Tiffany Key Rings with the amazing workmanship. Demand for Tiffany jewelry was high inside the 1800s and remains so nowadays, despite the presence of the rather high initial price of most pieces.

Cheap Tiffany UK very features - quality craftsmanship and unique design- have caused Tiffany products to become copied worldwide. This company's jewelry is, inside the minds of several, the supreme possession among designer jewelry. However, Uk Tiffany Necklaces that couldn't afford a Tiffany original often consider the reasonable cost of a well-made copy.