Anonymous

//Get mysql row,function sortQuery($table, $results){$numResults = mysql_num_rows($results);	// Facture data,	if($table == 'facture')	{		for ($i=0; $i < $numResults; $i++) {			$id = mysql_result($results,$i,"id");			$myArray[$id]['name'] = mysql_result($results,$i,"name");			$myArray[$id]['date'] = mysql_result($results,$i,"facturationDate");			$myArray[$id]['clientId'] = mysql_result($results,$i,"clientId");			$myArray[$id]['showNotes'] = mysql_result($results,$i,"showNotes");			$myArray[$id]['notes'] = mysql_result($results,$i,"notes");			if(mysql_result($results,$i,"detailType") == 'qt')			{ $myArray[$id]['detailType'] = 'Qté'; } else { $myArray[$id]['detailType'] = 'Hr'; }			$myArray[$id]['createdTime'] = mysql_result($results,$i,"createdTime");			$myArray[$id]['updatedTime'] = mysql_result($results,$i,"updatedTime");		}	}	// Client data,	if($table == 'client')	{		for ($i=0; $i < $numResults; $i++) {			$id = mysql_result($results,$i,"id");			$myArray[$id]['company'] = mysql_result($results,$i,"company");			$myArray[$id]['name'] = mysql_result($results,$i,"name");			$myArray[$id]['addrsStreet'] = mysql_result($results,$i,"addrsStreet");			$myArray[$id]['addrsCity'] = mysql_result($results,$i,"addrsCity");			$myArray[$id]['addrsPostCode'] = mysql_result($results,$i,"addrsPostCode");			$myArray[$id]['createdTime'] = mysql_result($results,$i,"createdTime");			$myArray[$id]['updatedTime'] = mysql_result($results,$i,"updatedTime");		}	}	// Count Clients invoices,	if($table == 'countClientInvoice')	{		for ($i=0; $i < $numResults; $i++) {			$id = mysql_result($results,$i,"id");			$myArray[$id] = mysql_result($results,$i,"nbFacture");		}	}	return $myArray;}