Advanced search working backwards

here is the situation. I have the advanced search up but if a male searches for female the return results are male. if the male searches for male then the return results are female. How can I fix this?

Thanks  in advance for any help

Bigdaddy,

turn em over

Regards,

DosDawg

it was a joke

uhhhh ok LOL how??? would it be some where in the search_adv.php?

I have tried

Try to change next code in search.php

$rProfiles = db_res( $sQuery );

to

$sOrder = " ORDER BY `DateLastLogin` DESC";

$rProfiles = db_res( $sQuery . $sOrder);

as well as adding

$sOrder = " ORDER BY `DateLastLogin` DESC";

before
//collect the whole query string
$sQuery = $sQuery . $sJoin . $sWhere . $sOrder;

and changing DateLastLogin to other parameters.

also tried match with field and match percent

is there something else I need to do?

I can not reproduce this problem on my site. So messing with the code is not the answer. It does not rewrite itself when uploaded to the server.

Have you verified you have your profile settings setup correctly.

IE. Your a Man looking for a Woman.

If the wrong box was selected during signup, the results would get reversed.

Yes. I log in as johndoe a man looking for a female. go to search and put in looking for female and the results come up with the male johndoe but when I put in looking for male the results come up with female janedoe. I also have many other search options available but this is the most important right now

ok I think I got it working. I had sex Male, female etc. then looking for sex male female etc. I removed the looking for and it worked

Thanks for the help everyone and happy new year

hopefully I wont have other problems  but as I am new to this advanced stuff  (only ever done very basic html)

I most likely will.