hi,
i wrote the following code, it is showing all records except the first record,
Code:
<table>
<tr>
<th>Username</th>
<th>Full Name</th>
<th>User Level</th>
<th>Action</th>
</tr>
<!-- START PHP Database Connectivity -->
<?php
include '../conn.php';
$sql="Select * from users";
$res = mysql_query($sql,$con);
$row=mysql_fetch_array($res);
?>
<!-- END PHP Database Connectivity -->
<!-- START showing data in table -->
<?php
while ($row=mysql_fetch_array($res))
{
echo "<tr align=\"left\">
<td>" . $row[1] . "</td>
<td>" . $row[3] . "</td>
<td>" . $row[4] . "</td>
<td>" . $row[3] . "</td>
</tr>";
}
?>
<!-- END showing data in table -->
</table>
</div>
<!-- END content div -->