Can't get search to display any results...

[hdezela]

What am I doing wrong here??

PHP code:

<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];

$default_sort = 'Nombre';
$allowed_order = array ('Nombre', 'Direccion','Internet','Distrito','Tema','Precio');
$default_dira = 'ASC';
$allowed_dira = array ('ASC','DESC');

if (!isset ($_GET['order']) || 
    !in_array ($_GET['order'], $allowed_order)) {
    $order = $default_sort;
} else {
    $order = $_GET['order'];
}

if (!isset ($_GET['dira']) || 
    !in_array ($_GET['dira'], $allowed_dira)) {
    $dira = $default_dira;
} else {
    $dira = $_GET['dira'];
}

$maxRows_Recordset1 = 4;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_quehacemos, $quehacemos);
$query_Recordset1 = "SELECT * FROM bares  WHERE Nombre LIKE '%$nombre%' AND Distrito LIKE '%$distrito%' AND Direccion LIKE '%$direccion%' AND Tema LIKE '%$tema%' AND Precio BETWEEN '%$preciomin%' AND '%$preciomax%' ORDER BY '%$order%' '%$dira%'";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $quehacemos) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . implode("&", $newParams);
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>

Form code:

<span class="buscar">
				<form class="buscaform" action="buscar.php" method="get" name="FormName" target="_self">
				<span class="buscaline">Nombre:&nbsp;<input class="cajas" type="text" name="nombre" value="" size="18" border="0">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Direccion:&nbsp;<input class="cajas" type="text" name="direccion" size="18" border="0">
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Distrito:&nbsp;<select class="cajas" name="distrito" size="1">
					<option value="">Cualquiera</option>
					<option value="San Isidro">San Isidro</option>
					<option value="Miraflores">Miraflores</option>
					<option value="Barranco">Barranco</option>
					</select>
				</span>

			<span class="buscaline">
				Tema:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<select class="cajas" name="tema" size="1">
				<option value="">Cualquiera</option>
				<option value="Irlandés">Irlandés</option>
				<option value="Cervezas">Cervezas</option>
				<option value="Tragos Varios">Tragos Varios</option>
				</select>

				&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Precio: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<select class="cajas" name="preciomin" size="1">
				<option value="0">Cualquiera</option>
				<option value="0">S/. 0.00</option>
				<option value="2">S/. 2.00</option>
				<option value="4">S/. 4.00</option>
				<option value="8">S/. 8.00</option>
				<option value="12">S/. 12.00</option>
				<option value="16">S/. 16.00</option>
				<option value="20">S/. 20.00</option>
				<option value="28">S/. 28.00</option>
				<option value="38">S/. 38.00</option>
				<option value="50">S/. 50.00</option>
				<option value="70">S/. 70.00</option>
				<option value="90">S/. 90.00</option>
				<option value="120">S/. 120.00</option>
				</select>
				&nbsp;&nbsp;&nbsp;&nbsp;a&nbsp;&nbsp;&nbsp;&nbsp;<select class="cajas" name="preciomax" size="1">
				<option value="2000">Cualquiera</option>
				<option value="4">S/. 4.00</option>
				<option value="8">S/. 8.00</option>
				<option value="12">S/. 12.00</option>
				<option value="16">S/. 16.00</option>
				<option value="20">S/. 20.00</option>
				<option value="28">S/. 28.00</option>
				<option value="38">S/. 38.00</option>
				<option value="50">S/. 50.00</option>
				<option value="70">S/. 70.00</option>
				<option value="90">S/. 90.00</option>
				<option value="120">S/. 120.00</option>
				<option value="150">S/. 150.00</option>
				<option value="2000">Sin Limite</option>
				</select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			</span>

			<span class="buscaline"><input class="boton" type="submit" name="Submit" value="Buscar">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input class="boton" type="reset" value="Borrar"></span>
			</form>
		</span>

I get no error message, just a blank query. You can try it out here.

[hdezela]

Errr....oddly enough, this page and its associated search page, with the exact same code (all I changed were the field names), works perfectly....maybe I've done something wrong with the table itself???

Here's the code for comparison:

<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];

$default_sort = 'Nombre';
$allowed_order = array ('Nombre', 'Direccion','Internet','Distrito','Comida','Delivery','Precio');
$default_dira = 'ASC';
$allowed_dira = array ('ASC','DESC');

if (!isset ($_GET['order']) || 
    !in_array ($_GET['order'], $allowed_order)) {
    $order = $default_sort;
} else {
    $order = $_GET['order'];
}

if (!isset ($_GET['dira']) || 
    !in_array ($_GET['dira'], $allowed_dira)) {
    $dira = $default_dira;
} else {
    $dira = $_GET['dira'];
}

$maxRows_Recordset1 = 4;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_quehacemos, $quehacemos);
$query_Recordset1 = "SELECT * FROM restaurant WHERE Nombre LIKE '%$nombre%' AND Distrito LIKE '%$distrito%' AND Direccion LIKE '%$direccion%' AND Comida LIKE '%$comida%' AND Delivery LIKE '%$delivery%' AND Precio BETWEEN $preciomin AND $preciomax ORDER BY $order $dira";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $quehacemos) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . implode("&", $newParams);
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>