search - what am i doing wrong

saint4

Hey all, please help me.

This is part of whats on the results page of a search.

How do i make it so if they didnt do a search for a city it will query the database for whatever has a value? if you get my meaning.

and if i add more fields how do i make it so if certain choses are blank not to sure at all or search for either.

example in the database you have MALE or FEMALE. if you chose on the search page for either what would be the value.

Thank you for your help in advance

   if (isset($_GET['advancesr'])||$_GET['advsrc']=="advancesr") {
	$advsrc = "advancesr";
	$query = "SELECT * FROM crib_users WHERE city='".$_GET['city']."'";
    if ($_REQUEST['gender']=="Male") $query .= " AND gender='Male'";
    if ($_REQUEST['gender']=="Female") $query .= " AND gender='Female'";
    if ($_REQUEST['online']=="1") $query .= " AND online='1'";

cornercuttinjoe

i cant really decipher what you mean.

"how do i make it so if they didnt do a search for a city it will query the database for whatever has a value" - what do you mean by this? do you mean if they dont enter a city, how do you do you perform the query with just the gener and online columns? i dont really know what youre asking.

"and if i add more fields how do i make it so if certain choses are blank not to sure at all or search for either" - this is not a real sentence. what do you mean? read this sentence out loud. i see you probably meant "choices" instead of choses, but as far as "are blank not to sure at all or search for either", you lost me.

restate it a little more clearly and i can probably help.

saint4

LOL. Sorry.

I think to far ahead when i type.

"how do i make it so if they didnt do a search for a city it will query the database for whatever has a value" - what do you mean by this? do you mean if they dont enter a city, how do you do you perform the query with just the gender and online columns? - Thats right.

If i added to the gender option 'EITHER'. how would i make it search for both male and female.

Thank you

cornercuttinjoe

ok, i see. well, if it doesnt matter, and you are doing a SELECT *, then why not just print out the gender anyway.

i.e.

$query = "SELECT * FROM ....";
$result = @mysql_query($query);

while ($row = mysql_fetch_array($result))
{
  echo $row['gender'];
}

what i am saying is, if you are going to do a query on whether a gender is male, female, or either, then you dont have to add that clause to your query because you are going to be using the gender anyway. you only have to add the "AND gender = ..." stuff for when you are looking for a specific gender.