<script language='JavaScript 1.2'>

function submitIt(form)
	{
	myOption = -1
	for (i=0; i<document.prodsearch.item.length; i++)
	{
		if (document.prodsearch.item[i].checked)
		{
		myOption = i
		}
			if (myOption == -1)
			{
			alert("You must make a selection.")
			return false
			}
	return true
}</script> 

<?php

// Program name: prodsearch.php
// Description: Program displays list of radio buttons with products grouped by category from product database info.


//set variables and implement error handling
 	require "includes/db.php";

//establish connection to host and db
  $connection=mysql_connect($host,$user,$password)
  	or die("Couldn't connect to server");
  $db=mysql_select_db($database,$connection)
  	or die("Couldn't select database");

// retrieve html header
	include_once ('templates/header.tpl');

// retrieve nav bar
	include_once ('templates/nav.tpl');

// create form containing radio buttons
	   	echo "<form onSubmit='return submitIt(this)' action='subtypemenu.php' method='POST'>\n";
//pass values from aniloc
	include_once('includes/passvalue.php');


// create page structure
 	echo "<h1><b>Search for $_POST[prodserv]s for $_POST[pet]s </b></h1>
	 <p>Please Choose the $_POST[prodserv] You Are Shopping for from Following List:</p>\n";



//category bit

//get category from the database
$query = "SELECT * FROM category
		  WHERE CATEGORY_TYPE = '$_POST[prodserv]'
		  AND ANIMAL_NAME='$_POST[pet]'";
		//removed	  ORDER BY CATEGORY_NAME

$category=@mysql_query($query)
	or showerror();
		while ($row=@mysql_fetch_array($category))
		{
			echo "<p class='guide'>";
			print $row['CATEGORY_NAME'];
			$NOW=$row['CATEGORY_ABBREV'];
			echo "</p>";


	//get product bit
				include ('includes/aniprod.php');

		}   //looping to get other categories

//fence footnote
include('includes/fenceftn.php');


//submit

 echo "<p><input type='submit' value='Select from $_POST[prodserv]s'></form>\n";

// retrieve footer
	include_once ('templates/footer.tpl');
?>

<?php
//Program: aniprod.php
//Description: this program selects only products that relate to a specific category abbrev to populate that category for prodsearch module


//query db
	 $query="SELECT * FROM product
	  	WHERE CATEGORY_ABBREV='$NOW'
	  	AND ANIMAL_NAME='$_POST[pet]'";
		//removed  	ORDER BY PRODUCT_NAME

	   $result=@mysql_query($query)
	or showerror();

	   	while ($row=@mysql_fetch_array($result))
	   	{

	 		extract($row);
	 		echo "<input type='radio' name='item' value='$PRODUCT_ABBREV'><b>$PRODUCT_NAME</b>\n";

	 		//fence footnote symbol
	 			include('includes/fenceftncondition.php');

	 		echo "<input type='hidden' name='issubtype' value='$ISSUBTYPE'>";

	 		echo "<br>\n";
	   	} 	 // looping to get other products under the same category




?>