[this is fetching the data, so i can edit and uppdate the required fields...]

$serverip="000.000.000.00";
$username="user";
$password="pass";
$database="database";
mysql_connect($serverip,$username,$password);
mysql_select_db($database);

$sql="SELECT * FROM anywhere order by a_id asc";

$res=mysql_query($sql);
?>

<table width="100%" border="0" cellspacing="2" cellpadding="0" >
<form id="form1" name="form1" method="post" action="update.php">
<tr bgcolor="#0099FF">
<td nowrap="nowrap" style="display:block">id</td>
<td nowrap="nowrap">name</td>
<td nowrap="nowrap">category_id</td>
<td nowrap="nowrap">owner_id</td>

</tr>

<?php while($row=mysql_fetch_array($res)) {?>
<tr>
<td style="display:block"><input name="auction_id" type="text" id="auction_id" value="<?=$row["auction_id"]?>" /></td>
<td nowrap="nowrap" height="30px"><input name="name" type="text" id="name" value="<?=$row["name"]?>" width="200px" height="100px" /> <br><hr></td>
<td nowrap="nowrap" height="30px"><input name="category_id" type="text" id="category_id" value="<?=$row["category_id"]?>" /> <br><hr></td>
<td nowrap="nowrap" height="30px"><input name="owner_id" type="text" id="owner_id" value="<?=$row["owner_id"]?>" /> <br><hr></td>

</tr>
<?php $rownum++;} ?>
<input type="submit" name="Submit" value="submit" />
</form>
</table>

[This is update.php file where the data will send to update]

<?php
$con = mysql_connect("000.000.000.00","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("database", $con);

$sql="UPDATE `anywhere` SET `a_id` = '$_POST[a_id]',`name` = '$_POST[name]',`country` = '1939',`zip_code` = '24240',`category_id` = '$_POST[category_id]',`owner_id` = '$_POST[owner_id]'";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "Product updated Successfully";

mysql_close($con)

?>