<?php include("top.php"); ?><?php$Venue_Name = $_POST['Venue_Name'];$City = $_POST['City'];$State = $_POST['State'];$query = mysql_query("SELECT * FROM Venues WHERE Venue_Name LIKE '%$Venue_Name%' AND City LIKE '%$City%' AND State LIKE '%$State%' and active=1 ORDER BY 'Venue_Name' ");while ($data = mysql_fetch_array($query)) {?><table width="500" cellpadding="5" cellspacing="1" border="1"><tr> <td width="500"> <br><b>Venue Name: </b><u><?=$data['Venue_Name'];?></u> <br><b>City, State, Zip </b> <u><?=$data['City'];?>, <?=$data['State'];?> <?=$data['Zip'];?> </u> <br> </td><tr> <td><center><a href="venue_preview.php?Venue_ID=<?=$data['Venue_ID'];?>">Look at This Venue</a></center></td></tr></table><p><?PHP};?><p><center>Dont See your venue listed? Click <a href="add_venue.php">here</a> to add it</P><br><br><p>Return to <a href="venue_search.php">Back to Search Page</a><center></P><?php include("bottom.php"); ?>