#!/bin/bash
PS3='Choose a Catagory: ' 
#set -x
echo
select cat in "Joe" "Dairy" "Bob" "Frank"

do
case "$cat" in
	
	Joe)
	echo "no Joe yet"
		;; 
	Dairy)
		DAIRY=1	
		PS4="Chose a Brand: "
		echo
		select brand in "hood" "nesquick"
			do
			case "$brand" in
				
				hood)
				BRAND=a
				PS5="Choose a Size: "
				echo 
				select size in "gal" "pint" 
                			do		
					case "$size" in
						gal)
			   			SIZE=1
			   			echo "getting $cat $brand $size for you"
			   			echo "These are the sql vars $DAIRY $BRAND $SIZE"
			   			mysql --execute="SELECT * FROM PRODUCTS WHERE REFERENCE rlike '^$DAIRY$BRAND$SIZE.';" tinapos
			   			;;
						pint)
			   			SIZE=4
			   			echo "getting $cat $brand $size for you"
			   			mysql --execute="SELECT * FROM PRODUCTS WHERE REFERENCE rlike '^$DAIRY$BRAND$SIZE.';" tinapos
			   			;;			   
					esac
					done
					;;

				nesquick)	
				BRAND=b
				PS5="Choose a Size: "
				echo 
				select size in "gal" "pint"
                			do		
					case "$size" in
						gal)
			   			SIZE=1
			   			echo "getting $cat $brand $size for you"
			   			echo "These are the sql vars $DAIRY $BRAND $SIZE"
			   			mysql --execute="SELECT * FROM PRODUCTS WHERE REFERENCE rlike '^$DAIRY$BRAND$SIZE.';" tinapos
			   			;;
						pint)
			   			SIZE=4
			   			echo "getting $cat $brand $size for you"
			   			mysql --execute="SELECT * FROM PRODUCTS WHERE REFERENCE rlike '^$DAIRY$BRAND$SIZE.';" tinapos
			   			;;
					esac
					done
					;;
			
			esac
			done		
			;;
	
	
esac
PS3="Choose a catagory: "
echo

done

exit 0