sql search query help

I have made a sql query to search a database on various fields that should be between a range of values or between various multiple choices

[code=php]
<?php require_once(‘Connections/dbconn.php’); ?>
<?php
$vareyecolor_rsVis = “%”;
if (isset($_POST[‘eye_color’])) {
$vareyecolor_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘eye_color’] : addslashes($_POST[‘eye_color’]);
}
$varbrlo_rsVis = “%”;
if (isset($_POST[‘brlo’])) {
$varbrlo_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘brlo’] : addslashes($_POST[‘brlo’]);
}
$varbrhi_rsVis = “%”;
if (isset($_POST[‘brhi’])) {
$varbrhi_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘brhi’] : addslashes($_POST[‘brhi’]);
}
$varwstlo_rsVis = “%”;
if (isset($_POST[‘wstlo’])) {
$varwstlo_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘wstlo’] : addslashes($_POST[‘wstlo’]);
}
$varwsthi_rsVis = “%”;
if (isset($_POST[‘wsthi’])) {
$varwsthi_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘wsthi’] : addslashes($_POST[‘wsthi’]);
}
$varhiplo_rsVis = “%”;
if (isset($_POST[‘hiplo’])) {
$varhiplo_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘hiplo’] : addslashes($_POST[‘hiplo’]);
}
$varhiphi_rsVis = “%”;
if (isset($_POST[‘hiphi’])) {
$varhiphi_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘hiphi’] : addslashes($_POST[‘hiphi’]);
}
$varhtlo_rsVis = “%”;
if (isset($_POST[‘htlo’])) {
$varhtlo_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘htlo’] : addslashes($_POST[‘htlo’]);
}
$varhthi_rsVis = “%”;
if (isset($_POST[‘hthi’])) {
$varhthi_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘hthi’] : addslashes($_POST[‘hthi’]);
}
$varhcolor_rsVis = “%”;
if (isset($_POST[‘hair_color’])) {
$varhcolor_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘hair_color’] : addslashes($_POST[‘hair_color’]);
}
$varwarea_rsVis = “%”;
if (isset($_POST[‘w_area’])) {
$varwarea_rsVis = (get_magic_quotes_gpc()) ? $_POST[‘w_area’] : addslashes($_POST[‘w_area’]);
}

if(empty($offset))
$offset=0;
define(ROWS,25);
mysql_select_db($database_dbconn, $dbconn);
$query_rsVis = sprintf(“SELECT users.id, users.color_eyes, users.foto1, users.foto2, users.foto3, users.alias_name, users.meas_bres, users.meas_waist, users.meas_hip, users.height, users.cv1_date, users.cv1_title, users.cv1_contents FROM users WHERE users.color_eyes=’%s’ AND users.meas_bres>’%s’ AND users.meas_bres<‘%s’ AND users.meas_waist>’%s’ AND users.meas_waist<‘%s’ AND users.meas_hip>’%s’ AND users.meas_hip<‘%s’ AND users.height>’%s’ AND users.height<‘%s’ AND users.hair_color=’%s’ AND users.w_area=’%s'”, $vareyecolor_rsVis,$varbrlo_rsVis,$varbrhi_rsVis,$varwstlo_rsVis,$varwsthi_rsVis,$varhiplo_rsVis,$varhiphi_rsVis,$varhtlo_rsVis,$varhthi_rsVis,$varhcolor_rsVis,$varwarea_rsVis);
$rsVis = mysql_query($query_rsVis, $dbconn) or die(mysql_error());

$totalRows_rsVis = mysql_num_rows($rsVis);

[/code]

Here the query only works if both the range of values is selected.

How do I modify this query if a person wants to give the option”All records” or does not insert any value in the range of values(that means all records ,of say meas_waist,no range to be specified)

Somebody pls help!!

Thanks

Ashokvas

Also in #PHP _↴