Recursive function

[cekirge]

Hi,
i have a code that will look get all the sub categories of the category, it might be 3 levels might be 4 who knows.

Here is my code, the only problem i am having is that $where displays nothing, it is empty.

function recursive($parent_id) {
    $sql =   "select cat_id from tablea where parent_id = $parent_id";
    $result =  mysql_query($sql);
    while ($row=mysql_fetch_array($result)) {
            $where .=" AND cat_id=". $row[cat_id];
            recursive($row[cat_id]);
    }

}
recursive($id);

any ideas?

[planetsim]

Well where is $where coming from.

You may want it in the function arguments or set it as a global within the function

[cekirge]

$where is an empty string in the beginning, after calling the function i am using the $where to search in mysql for something.

i never used global variables, how do i set it?

[planetsim]

Looking at your question again.

You are creating or starting to create an ever lasting loop.
You dont need to set it as a global or nothing..

You may need to rephrase the function a little to get away from the ever lasting loop..

[cekirge]

actually i found out how to set it as global variable and it worked, but i have a second question now
can i have OR statements in mysql search in where?

[laserlight]

yes, you can use OR

For example,

SELECT field FROM table WHERE field1='value1' OR field2='value2';

[planetsim]

Yes

Basics of an OR Statement

"SELECT * FROM tbl WHERE feild=feild OR feild=feild"

[cekirge]

thanks for your replies