public JSONArray listSubscriptions(String email){
		
		ResultSet rs = null;
		JSONArray subscriptionList = new JSONArray();
		
		try {
			String statement = "SELECT * FROM " + Constants.SUBSCRIPTIONS_TABLE + " WHERE email1=?;";
			PreparedStatement ps = conn.prepareStatement(statement);
			ps.setString(1, email);
			rs = ps.executeQuery();
			while(rs.next()){
				String subscription = rs.getString("email2");
				JSONObject j = new JSONObject();
				try {
					j.put("subscription", subscription);
				} catch (JSONException e) {
					e.printStackTrace();
				}
				
				subscriptionList.put(j);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
            try{
            	if(rs != null){
            		rs.close();
            	}
            } catch (SQLException e){
            	e.printStackTrace();
            }
        }
		
		return subscriptionList;
	}