All pastes #777647 Raw Edit

Something

public text v1 · immutable
·published 2007-11-16 22:51 UTC
rendered paste body
function getdb($table, $row, $where, $order)
{
	//Set where,
	$whereCall = '';
	if($where != false)
	{
		 $whereCall = ' WHERE '.$where;
	}
	//Set order,
	$orderCall = '';
	if($order != false)
	{
		 $orderCall = ' ORDER BY '.$order;
	}
	
	// Get datas,
	$query = 'SELECT '.$row.' FROM '.$table.$whereCall.$orderCall;
	$results = mysql_query($query);
	
	if($where) {
		// Facture datas,
		if($table == 'facture')
		{
			$myrow['factureId'] = mysql_result($results,0,"id");
			$myrow['factureName'] = mysql_result($results,0,"name");
			$myrow['factureDate'] = mysql_result($results,0,"facturationDate");
			$myrow['clientId'] = mysql_result($results,0,"clientId");
			$myrow['factureShowNotes'] = mysql_result($results,0,"showNotes");
			$myrow['factureNotes'] = mysql_result($results,0,"notes");
			if(mysql_result($results,0,"detailType") == 'qt')
			{ $myrow['factureDetilType'] = 'Qté'; } else { $myrow['factureDetilType'] = 'Hr'; }
		}
	}
	else
	{
		$myrow = mysql_query($query);
	}
	return $myrow;
}

getdb('facture','*','id = "55"', false);
print $myrow;