search problems

[Marc]

I am looking to a major problem with my search for genders in this script.
When selecting any on the website the script only comes up with couples looking_for couples.
When selecting male looking_for female it shows me all profiles.
Does anyone knows what is wrong here?
Thanks!

default:

if($gender != "any" && $gender != "")
{
$Result = mysql_query($Sql);
}

else if ($gender != "Couples" && $gender != "Couples")
{
$sql_where = "p.gender='".($gender[10] == C ? "Couples" : "Couples")."' and p.looking_for='".($gender[10] == C ? "Couples" : "Couples")."' ";
$Result = mysql_query($Sql);
}
else if ($gender != "Male" && $gender != "Female")
{
$sql_where = "p.gender='".($gender[0] == M ? "Male" : "Female")."' and p.looking_for='".($gender[1] == F ? "Female" : "Male")."' ";
$Result = mysql_query($Sql);
}

[volleytotal_ch]

if($gender != "any" && $gender != "") 
{ 
$Result = mysql_query($Sql); 
} 

else if ($gender != "Couples" && $gender != "Couples") // Why do you have this condition twice?
{ 
$sql_where = "p.gender='".($gender[10] == C ? "Couples" : "Couples")."' and p.looking_for='".($gender[10] == C ? "Couples" : "Couples")."' "; // Why $gender[10]? I Guess $gender[0]
// what is the difference between "Couples" and "Couples"?
$Result = mysql_query($Sql);  // Why don't you add $sql_where? -> mysql_query($Sql.$sql_where)
} 
else if ($gender != "Male" && $gender != "Female") 
{ 
$sql_where = "p.gender='".($gender[0] == M ? "Male" : "Female")."' and p.looking_for='".($gender[1] == F ? "Female" : "Male")."' "; 
$Result = mysql_query($Sql); // Why don't you add $sql_where? -> mysql_query($Sql.$sql_where)
}

please send us more code! or explain us what you want to do exactly!
i guess that you make a big mistake with your if conditions! but i can't say because i don't know what you want to do exactly 🙁

[Marc]

The part of this code is to search for matches in the mysql.
When someone selects i'm male seeking females, the males are showing up.
If for instance they select i'm a couple looking for couple, only they show up etc.......
The full code of the script is here.
if you want i can send it to you by mail if that is easier.
Mail is [e-mail]

Thanks
Marc

<?
if($action == process_search)
{
// Collecting search tokens & search tables

		$sql_from = dt_profile;
		$sql_where = "";
		$sql_vars = "*";

		switch($search_type)
		{
			case member_code:

				$sID = $membercode;
				$sID[ 0 ] = " ";

				for($i = 0; $i < strlen($sID);$i++)
				{
					if($sID[ $i ] != "0" && $sID[ $i ] != " ")
					{
						$sID = (int)$sID;
						break;
					}
					$sID[ $i ] = " ";
				}
                                    $sql_from = "dt_profile AS p";
				$sql_where = "member_id='$sID'";

				break;

			case profile_name:
                                    $sql_from = "dt_profile AS p";
				$sql_where = "name LIKE '%$profile_name%'";

			default:

	        if($gender != "any" && $gender != "")
	       {
	                 $nWas = 0;
	       }

	        if($gender != "couple" && $gender != "couple")
          { 	
			          	$sql_where = "p.gender='".($gender[10] == c ? "couple" : "couple")."' and p.looking_for='".($gender[10] == c ? "couple" : "couple")."' ";
                    $Result = mysql_query($Sql); 
          }
           if($gender != "male" && $gender != "female")
          {                 
                    $sql_where = "p.gender='".($gender[0] == m ? "male" : "female")."' and p.looking_for='".($gender[1] == f ? "female" : "male")."' ";
					    $Result = mysql_query($Sql);
			}  

				if($age_from != "")
				{
					$year = date("Y") - $age_from;
					$sql_where .= ($nWas ? "and " : "")."p.birth_year<='$year' ";
					$nWas = 1;
				}

				if($age_to != "")
				{
					$year = date("Y") - $age_to;
					$sql_where .= ($nWas ? "and " : "")."p.birth_year>='$year' ";
					$nWas = 1;
				}

				if($country != "")
				{
					$sql_where .= ($nWas ? "and " : "")."p.country='$country' ";
					$nWas = 1;
				}

				if($city != "")
				{
					$sql_where .= ($nWas ? "and " : "")."p.city LIKE '%$city%' ";
					$nWas = 1;
				}

				if($state != "")
				{
					$sql_where .= ($nWas ? "and " : "")."p.state LIKE '%$state%' ";
					$nWas = 1;
				}
                                    if ($piconly != "")
                                    {
                                            $sql_where .= ($nWas ? "and " : "")."f.member_id = p.member_id and f.filename_1 <> ''";
					$nWas = 1;
                                            $sql_from = "dt_profile AS p, dt_photos as f";
                                    }
                                    else
                                    {
                                            $sql_from = "dt_profile AS p";
                                    }

				//	Easily it is EASY SEARCH
		}
		$search_query = "SELECT $sql_vars, p.id FROM $sql_from WHERE (p.status='1' ".($sql_where == "" ? ")" : " AND $sql_where)");
		$profiles = q($search_query);

		include "templates/search_results.ihtml";
	}
            else if($action == process_quicksearch)
            {
                 if($gender != "any" && $gender != "")
                 {
                     $sql_where = "gender='".($gender[ 0 ] == M ? "Man" : "Vrouw")."' and looking_for='".($gender[1] == V ? "Vrouw" : "Man")."' ";
	         $nWas = 1;
                 }
	     if($age_from != "")
	     {
                     $year = date("Y") - $age_from;
	         $sql_where .= ($nWas ? "and " : "")."birth_year>='$year' ";
		 $nWas = 1;
	     }
	     if($age_to != "")
	     {
		$year = date("Y") - $age_to;
		$sql_where .= ($nWas ? "and " : "")."birth_year<='$year' ";
		$nWas = 1;
	     }
                 if ($radius != "" && $zipcode != "")
                 {
                     $zipsrch = "select longw,latn from dt_zips where zipcode = '$zipcode'";
                     $ARET = f(q($zipsrch));
                     $istartlong = $ARET["longw"];
                     $istartlat = $ARET["latn"];

                    $iRadius = $radius;
                    $LatRange = ($iRadius / ((6076 / 5280) * 60));
                    $LongRange = ($iRadius / (double)(((cos($istartlat * 3.141592653589 / 180) * 6076) / 5280) * 60));

                    $LowLatitude = $istartlat - $LatRange;
                    $HighLatitude = $istartlat + $LatRange;
                    $LowLongitude = $istartlong - $LongRange;
                    $HighLongitude = $istartlong + $LongRange;

                    $distsrch = "SELECT zipcode FROM dt_zips WHERE (latn <= '$HighLatitude') AND (latn >= '$LowLatitude') AND (longw >= '$LowLongitude') AND (longw <= '$HighLongitude')";
                    $QRETURN1= q($distsrch);

                    $QNUM = (int)nr($QRETURN1);
                    $i = 0;
                    while ($ARET1 = f($QRETURN1))
                    {
                      if ($i == 0)
                      {
                          $zip = "zipcode = '" . $ARET1["zipcode"] . "'";
                          $i = 1;
                      }
                      else
                      {
                          $zip .= " OR zipcode = '" . $ARET1["zipcode"] . "'";
                      }
                    }

                    $sql_where .= ($nWas ? "and " : ""). $zip." ";
		$nWas = 1;
                 }
                                    if ($piconly != "")
                                    {
                                            $sql_where .= ($nWas ? "and " : "")."f.member_id = p.member_id and f.filename_1 <> ''";
					$nWas = 1;
                                            $sql_from = "dt_profile AS p, dt_photos as f";
                                    }
                                    else
                                    {
                                            $sql_from = "dt_profile AS p";
                                    }
		$search_query = "SELECT *, p.id FROM $sql_from WHERE (p.status='1' ".($sql_where == "" ? ")" : " AND $sql_where)");
                    $profiles = q($search_query);

		include "templates/search_results.ihtml";

            }
	else
	{
		include "templates/easy_search.ihtml";
	}

?>

[volleytotal_ch]

i just sent you an email!