In php delete the row in html table:
Hi to everyone,
I have a problem in deleting the single row in html table.In html table each row has a delete link and auto_increment id.if u click the delete link the particular row has been deleted in both the html table and the database also.

//code for delete.php

$user = "root";
$pwd = "";
$host = "localhost";
$dbname = "phptable";




$result=mysql_query("DELETE FROM estate WHERE Area=$id");

echo "No data is passed<br/>";

$conn = mysql_connect($host,$user,$pwd) or ("<br>[en] ERROR on MySQL server connection");
echo "<b>your resource to MySQL Server is ok";
echo "<br><b>you have selected $dbname<br/>";


<a href ="jtable.php">click here to go back to the records</a>


//code for html table page

while($row = mysql_fetch_array($result))
if($num % 2 ==0)

	echo "<tr bgcolor=$bgcolor>"; 
	echo "<td>".'<input type="checkbox" name="checkbox" />'."</td>";
 	echo "<td>".'<a href="update.php">Edit</a>'."</td>";
	echo "<td>".'<a href="delete.php">Delete</a>'."</td>";
        echo "<td>" . $row['id'] . "</td>"; 
	echo "<td>" . $row['Area'] . "</td>";
 	echo "<td>" . $row['Property'] . "</td>";
	echo "<td>" . $row['Bedroom'] . "</td>";
	echo "<td>" . $row['Bathroom'] . "</td>";
	echo "<td>" . $row['Budget'] . "</td>";   
	echo "<td>" . $row['Footage'] . "</td>";
	echo "<td>" . $row['Parktype'] . "</td>";
	echo "<td>" . $row['Smoker'] . "</td>";
	echo "<td>" . $row['Petshave'] . "</td>";
	echo "</tr>";
echo "</table>";

i got "No data is passed".
The value is passed from php validation page.How to pass the value.
I want your help..


Pass the id value in line number 66 & 67 for update and Delete option.


<a href="delete.php?id=$row['id']">Delete</a>