Re: function I created doesn't work

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



afan pasalic wrote:
> 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);

		return get_content(0, 0, $index1);
you need to return the results of the second call.

When you hit the second call, you are not returning the results.

> 	}
> }
> 
> 
> get_content(12, 104, 'merchant');
> echo $CONTENT; 	# Shows correct.
> 
> What's wrong with first solution?
> 
> Thanks for any help.
> 
> -afan
> 


-- 
Jim Lucas

   "Some men are born to greatness, some achieve greatness,
       and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V
    by William Shakespeare

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux