How to check if the function call is first or not in recursive function?

[PHPycho]

Suppose i have following recursive function(dummy):

function someRecursiceFunc($id){	
	if(/*check_if_call_is_first*/){
		//want to do some operations here with the $id
	}
	$sql 		= "SELECT id, parent_id, title FROM some_table WHERE id = ".(int)$id;
	$db_result 	= mysql_query($sql);
	while($row 	= mysql_fetch_array($db_result)){
		someRecursiveFunc($row['parent_id']);
	}
}

i tried with the static $count = 0 & incremented in while() loop
but this caused problem in function call inside loop(as static variable preserves the value)
For example:

foreach($datas as $data){
	someRecursiveFunc($data['id']);//value of $count went increasing
}

is there any techinque so that i can check for first call?

[dagon]

just add an argument to someRecursiceFunc()

function someRecursiceFunc($id,$first=FALSE){

if($first){
    //want to do some operations here with the $id
}
$sql         = "SELECT id, parent_id, title FROM some_table WHERE id = ".(int)$id;
$db_result     = mysql_query($sql);
while($row     = mysql_fetch_array($db_result)){
    someRecursiveFunc($row['parent_id']);
}
} 

}

someRecursiceFunc($id,TRUE);

[laserlight]

A better solution is to use two functions: a non-recursive function that is called by the user, and a recursive helper function that this non-recursive function calls.

Actually, it would be even better to change the recursion into iteration and reduce the number of query executions by combining the ids into a list.

[jay6390]

laserlight has hit it on the head. You should make your queries more streamlined and create a better one

As for the function, I'd do as dagon suggested and add a second parameter, only instead of false, use a counter (default value 0) and add one to it each iteration. That way, you can tell exactly what iteration it is

function someRecursiceFunc($id, $level = 0) {
	$level++;
	$sql = "SELECT id, parent_id, title FROM some_table WHERE id = ".(int)$id;
	$db_result = mysql_query($sql);
	while ($row = mysql_fetch_array($db_result)) {
		someRecursiveFunc($row['parent_id'], $level);
	}
}