route add 10.79.129.0 mask 255.255.255.0 192.168.101.5

class Inventory
{
	var $my_array = array();
	function Inventory($parent_id='', $level=0)
	{
		//constructor calls inner function
		$this->find_inv($parent_id, $level);
	}
	
	/**
	 * Function to print out inventory

Loc_id  Part_id  Qty
+1      ABC      5
--3     ABC      2
-+4     ABC      3
  --5   ABC      1
  --6   ABC      2

create procedure cursorproc(IN p_in INT, OUT p_out VARCHAR(30))
begin

   declare l_emp_name VARCHAR(30);
   declare cur_1 cursor for select emp_name from emps where emp_id = p_in;

   open cur_1;
   fetch cur_1 into l_emp_name;
   close cur_1;

   set p_out = l_emp_name;

end;

SELECT a.reference_no, b.order, b.date
FROM table_a AS a
LEFT JOIN table_b AS b ON a.reference_no=b.reference_no
WHERE b.order=1

 /**
 *
 * Sanitizes data that is passed to it for entry into mysql database.