<table width="100%" align="center">
<tr>
<th align="left" valign="top" bgcolor="#000000" scope="row"><div align="center">
<p> </p>
<p><strong><u>DATA</u></strong> </p>
<form id="form3" name="form3" method="post" action="update.php">
<p>
<?php
include "connection.php";
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
?>
</p>
<table width="450" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
<tr>
<td width="23" align="center" bgcolor="#000000"> </td>
<td width="22" align="center" bgcolor="#000000"><div align="left"></div></td>
<td width="120" align="center" bgcolor="#000000"><div align="left"><strong>Username</strong></div></td>
<td width="120" align="center" bgcolor="#000000"><div align="left"><strong>Password</strong></div></td>
<td width="153" align="center" bgcolor="#000000"><div align="left"><strong>Email</strong></div></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#000000"><? echo $rows['id']; ?></td>
<td bgcolor="#000000"><div align="left"></div></td>
<td bgcolor="#000000"><div align="left">
<input name="username2" type="text" id="username3" value="<? echo $rows['username']; ?>" />
</div></td>
<td width="120" align="center" bgcolor="#000000"><div align="justify">
<input name="password2" type="text" id="password3" value="<? echo $rows['password']; ?>" />
</div></td>
<td width="153" align="center" bgcolor="#000000"><div align="justify">
<input name="email" type="text" id="email2" value="<? echo $rows['email']; ?>" />
</div></td>
</tr>
<?php
}
?>
<tr>
<div>
<td align="center" bgcolor="#000000"><div align="left"></div></td>
<td align="left" bgcolor="#000000"> </td>
<td align="left" bgcolor="#000000"> </td>
<td align="left" bgcolor="#000000"> </td>
<td align="left" bgcolor="#000000"> </td>
</div>
</tr>
<tr>
<td colspan="5" align="left" bgcolor="#000000"><input name="update" type="submit" id="update" value="Update" /></td>
</tr>
<?
if($_POST['update'] == 'Update'){
for($i=0;$i<$count;$i++){
$update = "UPDATE $tbl_name SET username='$username', password='$password', email='$email' WHERE id='$id'";
mysql_query($update) or die(mysql_error());
echo "<meta http-equiv='refresh' content='2;url=update.php>";
}
else {
echo "SORRY TRY AGAIN";
echo "<meta http-equiv='refresh' content='2;url=update.php'>";
}
mysql_close();
?>
</table>
</form>
<p> </p>
<p> </p>
</div></th>
</tr>
</table>