Code: Select all
<?php require_once('../Connections/connNightspotz.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_rsSRCH = 10;
$pageNum_rsSRCH = 0;
if (isset($_GET['pageNum_rsSRCH'])) {
$pageNum_rsSRCH = $_GET['pageNum_rsSRCH'];
}
$startRow_rsSRCH = $pageNum_rsSRCH * $maxRows_rsSRCH;
$AC_rsSRCH = "1";
if (isset($_POST['areacode'])) {
$AC_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['areacode'] : addslashes($_POST['areacode']);
}
$VN_rsSRCH = "2";
if (isset($_POST['venuename'])) {
$VN_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['venuename'] : addslashes($_POST['venuename']);
}
$VT_rsSRCH = "3";
if (isset($_POST['venuetype'])) {
$VT_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['venuetype'] : addslashes($_POST['venuetype']);
}
$AG_rsSRCH = "4";
if (isset($_POST['agegroup'])) {
$AG_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['agegroup'] : addslashes($_POST['agegroup']);
}
$MT_rsSRCH = "5";
if (isset($_POST['musictype'])) {
$MT_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['musictype'] : addslashes($_POST['musictype']);
}
mysql_select_db($database_connNightspotz, $connNightspotz);
//-----this is the correction-----------
$query_rsSRCH = sprintf ("SELECT * FROM venues");
if (!empty($_POST['venuename']))
{
$sql .= " and VT = '" . $_POST['venuename']."' ";
}
if (!empty($_POST['areacode']))
{
$sql .= " and AC = '" . $_POST['areacode']."' ";
}
if (!empty($_POST['venuetype']))
{
$sql .= " and VT= '" . $_POST['venuetype']."' ";
}
if (!empty($_POST['agegroup']))
{
$sql .= " and AG = '" . $_POST['agegroup']."' ";
}
if (!empty($_POST['musictype']))
{
$sql .= " and MT = '" . $_POST['musictype']."' ";
}
//-------------------------------------------
$query_limit_rsSRCH = sprintf("%s LIMIT %d, %d", $query_rsSRCH, $startRow_rsSRCH, $maxRows_rsSRCH);
$rsSRCH = mysql_query($query_limit_rsSRCH, $connNightspotz) or die(mysql_error());
$row_rsSRCH = mysql_fetch_assoc($rsSRCH);
if (isset($_GET['totalRows_rsSRCH'])) {
$totalRows_rsSRCH = $_GET['totalRows_rsSRCH'];
} else {
$all_rsSRCH = mysql_query($query_rsSRCH);
$totalRows_rsSRCH = mysql_num_rows($all_rsSRCH);
}
$totalPages_rsSRCH = ceil($totalRows_rsSRCH/$maxRows_rsSRCH)-1;
$queryString_rsSRCH = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsSRCH") == false &&
stristr($param, "totalRows_rsSRCH") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsSRCH = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsSRCH = sprintf("&totalRows_rsSRCH=%d%s", $totalRows_rsSRCH, $queryString_rsSRCH);
$queryString_rsSrch = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsSrch") == false &&
stristr($param, "totalRows_rsSrch") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsSrch = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsSrch = sprintf("&totalRows_rsSrch=%d%s", $totalRows_rsSrch, $queryString_rsSrch);
?>
<?php
$query_venues = "DELETE FROM venue";
mysql_query($query_venue,$srch);
?>and here's how my table in the database is set up:
Code: Select all
<table name="venues">
<fields>
<field name="v_nID" size="5" scale="0" type="int" auto_increment="auto_increment" key="PRI" default="" null="" />
<field name="venuename" size="50" scale="0" type="varchar" key="" default="" null="" />
<field name="address" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="city" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="state" size="50" scale="0" type="varchar" key="" default="" null="" />
<field name="zipcode" size="10" scale="0" type="varchar" key="" default="" null="" />
<field name="country" size="50" scale="0" type="varchar" key="" default="" null="" />
<field name="areacode" size="3" scale="0" type="char" key="" default="" null="" />
<field name="phonenumber" size="10" scale="0" type="varchar" key="" default="" null="" />
<field name="faxnumber" size="10" scale="0" type="varchar" key="" default="" null="" />
<field name="email" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="website" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="venuetype" size="200" scale="0" type="varchar" key="" default="" null="" />
<field name="agegroup" size="10" scale="0" type="varchar" key="" default="" null="" />
<field name="musictype" size="250" scale="0" type="varchar" key="" default="" null="" />
<field name="dresscode" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="payment" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="venuelogo" type="blob" key="" default="" null="" />
</fields>
</table>