Here's my codeWarning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/iwinall/public_html/clan/members/memberslist.php on line 14
Code: Select all
<?php
$pagename = "Members List";
include("includes/header.php");
//Connect
$db = mysql_connect("localhost","bert","**********");
mysql_select_db("bert",$db);
//Querying
$requete = "SELECT * FROM members";
$result = mysql_query ($requete,$db);
$article = mysql_fetch_object($result);
mysql_free_result($result);
$row = mysql_num_rows($result);
//Display
print("<table border=1>
<tr>
<td><b>Name:</b></td>
<td><b>Rank:</b></td>
<td><b>Points:</b></td>
<td><b>Positions:</b></td>
<td><b>Certificates:</b></td>
<td><b>Awards:</b></td>
<td><b>Join Date:</b></td>
</tr>
");
$count=0;
while($count!=$row){
print("
<tr>
<td>$article->name</td>
<td>$article->rank</td>
<td>$article->points</td>
<td>$article->positions</td>
<td>$article->certificates</td>
<td>$article->awards</td>
<td>$article->jdate</td>
</tr>
");
$count++;};
print("</table>");
include("includes/footer.php");
?>
?>Code: Select all
$row = mysql_num_rows($result);
?>