Form output using mysql, search people name in specific category

[basketmen]

I have search php forms that connecting to mysql, for search people name in all category and search people name in specific category

People name field in mysql : people_name , example : John, Michael, etc
category name field in mysql : people_category , example : Kid, Adult, etc


I can Search All People name using first option value below, for example i search : John

beside that i want to search : John only in adult category

what is the right code so i can get people name just from adult category

<select name="metode" size="1">
<option value="people_name">Search All People</option>
<option value="people_name_just_from_adult_category">Search People By Category</option>
</select>
<input type="text" name="search" size="25">
<input type="submit" value="Search" name="Go" />

Please share your php mysql knowledge here

[mangome]

you need another list for categories.

[Izzmo]

Basketmen,
Looking at your code, you have radio buttons, and in that list, you can only select 1 item. You will need to set those as "checkboxes".

Once you get that done, you need simple do:

PHP Code:

if(isset($_POST["people_name_just_from_adult_category"]))
    $sql = "SELECT people_name,people_category FROM people WHERE people_name = '".$_POST["people_name"]."' AND people_category = 'adult'";
else
    $sql = "SELECT people_name,people_category FROM people WHERE people_name = '".$_POST["people_name"]."'"; 


If you need any more help, I'd be of some assisstance.

[mangome]

can you provide more info on what you want?