function I created doesn't work

[afan pasalic <afan@xxxxxxxx>]

hi
I have function
function get_content($client_id, $form_id, $index1)
{
	$query = mysql_query("
			SELECT content
			FROM infos
			WHERE client_id=".$client_id." AND form_id=".$form_id." AND
index1='".$index1."'");
	if (mysql_num_rows($query) > 0)
	{
		$result = mysql_fetch_assoc($query);
		return $result['content'];
	}
	else
	{
		get_content(0, 0, $index1); // get default value
	}
}

When I call it
$CONTENT = get_content(12, 104, 'merchant');
echo $CONTENT; // empty, nothing

But if I use global in the function

function get_content($client_id, $form_id, $index1)
{
	global $CONTENT;
	$query = mysql_query("
			SELECT content
			FROM infos
			WHERE client_id=".$client_id." AND form_id=".$form_id." AND
index1='".$index1."'");
	if (mysql_num_rows($query) > 0)
	{
		$result = mysql_fetch_assoc($query);
		$CONTENT = $result['content'];
	}
	else
	{
		get_content(0, 0, $index1);
	}
}


get_content(12, 104, 'merchant');
echo $CONTENT; 	# Shows correct.

What's wrong with first solution?

Thanks for any help.

-afan

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php