<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'work';
mysql_select_db($dbname);


$id=$_POST["Userid"];


$sql="SELECT * FROM summer_packages WHERE userid='$id' ";
$result=mysql_query($sql);

print " <centre>
<table border=\"5\" cellpadding=\"5\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#808080\" width=\"10%\" id=\"AutoNumber2\" bgcolor=\"#FFFFFF\"><tr>
<td width=100>userid:</td>
<td width=100>name:</td>
<td width=100>descr:</td>
<td width=100>duration:</td>
<td width=100>location:</td>
<td width=100>brange:</td>
<td width=100>price:</td>
<td width=100>no_of_pax:</td>
</tr>";

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
print "<tr>";
print "<td>" . $row['userid'] . "</td>";
print "<td>" . $row['name'] . "</td>";
print "<td>" . $row['players'] . v . $row['players'] . "</td>";
print "<td>" . $row['duration'] . "</td>";
print "<td>" . $row['location'] . "</td>";
print "<td>" . $row['brange'] . "</td>";
print "<td>" . $row['price'] . "</td>";
print "<td>" ."<input type=\"button\" />". "</td>";
print "</tr>";
}
print "</table> ";





echo "$id";

?>