$objConn = setDbConn();
  	
  	$strSQL  = "CALL mp_proc_getHomePageProjNews('Chennai')";  	
  	
	 if($objConn->multi_query($strSQL)) 
	 {
		do 
		{		
	  		$l = 0;
				/* store first result set */
				if ($result = $objConn->use_result()) 
				{
	
					while($row = $result->fetch_row()) 
					{
					  $arrTempResult[] = $row;
					}
	
					$arrResult[] = $arrTempResult;						
					unset($arrTempResult);
													
					$result->close();
				}
			
				if($objConn->more_results()) 
				{
				}			 
		 } while ($objConn->next_result());
	 } 

Leave a reply