Search:

Ok, just for reference, I think I figured it out:

$search_query="";
if ($cat1>0){
$search_query.=" AND r.category_2 = ".$cat1;
}
if ($subcat1>0){
$search_query.=" AND r.category_3 =...

The problem is that they are related - that's why I used 3 levels for relation, and I'm searching by 2 of them.
I have a problem constructing the query:

For example I have:
Table relations:...

Hello,

I think I'm stuck at this problem now and I'm not sure how to proceed.
Here's the task: a php site with different registered users.
Every user can create a directory.
Every directory can...