Webmaster Forum - View Single Post - Form output using mysql, search people name in specific category

Izzmo · 03-25-2008, 01:28 PM

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.

03-25-2008, 01:28 PM	#3 (permalink)
Izzmo Contributing Member Join Date: 11-01-03 Location: Kansas City Posts: 1,067 iTrader: 0 / 0% Latest Blog: Moved In!	Here you go 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. __________________ █ Izzmo █ Coding Guru Extraordinaire █ ZeroWeb Hosting & Design - Customizable hosting for every type of user!