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 Please share your php mysql knowledge here
What you have there is an HTML form not PHP code. What exactly did you want? I would make the form with the drop/combo down box select your category have it blank as the default for all categories. Then make your php code do a conditional mysql query depending if category has a valid value passed or not. That's the 1000 foot view. If you have some specific code you need help with post it using the PHP tag in the forum.