public String outputHHweek(ResultSet weekRes, String start_date, String time)
	{
		String pg = "";
		int numPizzas;
		double pizzaRevenue;
//		AdminQuery adminQuery = new AdminQuery();
		try {
			if (weekRes.next())
			{
				pg += "<b>Week "+time+" "+start_date+"</b><br>";
				pg += "<table border='1'>";
				pg += "<tr><td><div id='table_hdr'>Date</div></td><td><div id='table_hdr'>Number Pizzas Sold</div></td><td><div id='table_hdr'>Total Revenue</div></td></tr>";
				do
				{
					numPizzas = 0;
					pizzaRevenue = 0.0;
				    String daySym = computeDay(weekRes.getString(5).trim());
				    Integer trans_id = Integer.parseInt(weekRes.getString(1));
				    String t_time = weekRes.getString(4).trim();
				    String t_date = weekRes.getString(2).trim();
				    String to_timestamp = "to_timestamp('04-01-12 "+t_time+"', 'MM-DD-YY HH24:MI')";
				    
				    /*This query returns pizzaId, and price for a HH on a given day */
				    String hhPricequery = "select price, item_id from happyprices where "+to_timestamp+
							  				" >= start_time AND "+to_timestamp+" <= end_time AND day = '"+daySym+"'";
//				    System.out.println(hhPricequery);
				    ResultSet hhResult = executeQuery(hhPricequery);
				    ArrayList<String> hhPrices = new ArrayList<String>();
				    ArrayList<String> hhIds = new ArrayList<String>();
				    if (hhResult.next())
				    {
				    	do
				    	{
//				    		System.out.println("hhResult loop");
				    		hhPrices.add(hhResult.getString(1).trim());
				    		hhIds.add(hhResult.getString(2).trim());
				    	}while (hhResult.next());
				    }
				    
				    /*This query will return the pizza_ids for a particular transaction */
				    String pizza_query = "select pizza_id, qty from trans_p where trans_id = "+trans_id;
				    ResultSet pizza_res = executeQuery(pizza_query);
				    if (pizza_res.next())
				    {
				    	do
				    	{
//				    		System.out.println("pizza_res loop");
				    		String p_id = pizza_res.getString(1).trim();				    		
				    		Integer p_qty = Integer.parseInt(pizza_res.getString(2));
				    		/* retreive the HH price for this pizza ID */
				    		int i = 0;
				    		for (String id : hhIds)
				    		{
//				    			System.out.println("FOR LOOP");
				    			//This pizza is a HH pizza
				    			if (id.equals(p_id))
				    			{
//				    				System.out.println("if");
				    				numPizzas += 1;
					    			Double hhprice = Double.valueOf(hhPrices.get(i));
					    			pizzaRevenue += (p_qty * hhprice);
					    			Formatter fmt_rev = new Formatter(); 
								    fmt_rev.format("%.2f", pizzaRevenue);
								    pg += "<tr><td>"+t_date+"</td><td><center>"+numPizzas+"</center></td><td><center>$"+fmt_rev+"</center></td></tr>";
				    			}
				    			i++;
				    		}
				    	}while (pizza_res.next());
				    }
				}while (weekRes.next());
				pg += "</table>";
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
		return pg;
	}