Execute Scalar and Execute Row for Php

A couple of simple functions thar returns the first value and the first row of a result set. Very usefull.…

A couple of simple functions thar returns the first value and the first row of a result set.

Very usefull.

Need the connection to be opened.

$user = execute_row("select * from user where id='23'");
$value = execute_scalar("select name from users where id='23'");

// $user['name'] is the same of $value;

function execute_scalar($sql,$def="") {
	$rs = mysql_query($sql) or die("bad query");
	if (mysql_num_rows($rs)) {
		$r = mysql_fetch_row($rs);
		mysql_free_result($rs);
		return $r[0];
		mysql_free_result($rs);
	}
	return $def;
}

function execute_row($sql) {
	$rs = mysql_query($sql) or die("bad query");
	if (mysql_num_rows($rs)) {
		$r = mysql_fetch_array($rs);
		mysql_free_result($rs);
		return $r;
	}
	mysql_free_result($rs);
	return "";
}