Help with PHP Coding......

russellcox77777

I wonder if anybody can help me code this page just to display "Travel Inn" records from the table "tickets2_info" in mysql

This is what I have but would also like to select the hotel.

$sql = "select * from tickets2_info ORDER BY tickets2_info.ticket_id ASC";

*tickets2_info

 $list .= "<td>".$row["hotel"]."</td>";
 $list .= "<td>".$row["ticket_id"]."</td>";
 $list .= "<td>".$row["name"]."</td>";
 $list .= "<td>".$row["staff"]."</td>";
 $list .= "<td>".$row["room"]."</td>";
 $list .= "<td>".$row["email"]."</td>";
 $list .= "<td>".$row["tel"]."</td>";
 $list .= "<td>".$row["required"]."</td>";

thorpe

your going to need to be a bit more specific. doesn't this...

 $list .= "<td>".$row["hotel"]."</td>";

display the hotel?

eriksmoen

maybe try something like:


$thehotel = (isset($_GET['hotel']))? $_GET['hotel'] : "%";

$sql = "select * from tickets2_info WHERE tickets2_info.hotel LIKE('$thehotel') ORDER BY tickets2_info.ticket_id ASC";

and for you hotel selection box:


$query = @mysql_select("SELECT hotel FROM tickets2_info GROUP BY hotel ORDER BY hotel");
echo "<form action='".$_SERVER['PHP_SELF']."' method='GET'>";
echo "<select name='hotel'>";
while($result = @mysql_fetch_array($query))
{
    echo "<option value='$result[hotel]'>$result[hotel]";
}
echo "</select>";
echo "<input type='submit' value='go'>";
echo "</form>";