hai
i am retriving records from databases based on some condition . i am selecting the some records by checkbox .i need help here . i am going to compare records details in the next file from selected checkboxes. please help me how can i do
<?php
ob_start();
include "userchk.php";
@extract('$POST');
$tran_type=$POST["property_for"];
$pro_type=$POST["property_type"];
$city=$POST["city"];
$budget=$POST["budget"];
$bedroom=$POST["bedroom"];
$row=mysql_query("select * from pro_table where tran_type='$tran_type' AND pro_type='$pro_type' AND city='$city' AND bedroom='$bedroom'");
$con=mysql_num_rows($row);
if($con!=0)
{
echo "<table border='5'><th>Transaction Type</th><th>Property Type</th><th>City</th><th>Budget</th><th>Bedroom</th>";
while($query=mysql_fetch_array($row))
{
echo "<tr><td><input type='checkbox' >";
echo $query['tran_type']."<br/>";
echo "</td><td>";
echo $query['pro_type']."<br/>";
echo "</td><td>";
echo $query['city']."<br/>";
echo "</td><td>";
echo $query['budget']."<br/>";
echo "</td><td>";
echo $query['bedroom']."<br/>";
echo "</td></tr>";
}
echo "</table>";
}
else
{
?>
<table align="center" border="5" width="50%" height="30%" bordercolor="blue"><tr><td align="center">
<?php echo "record not found";?></td></tr></table>
<?php
}
?>
