despite all your very good info Vincen, I still haven't got the result I am looking for...
Here is one more try to give the full picture on what I am trying to do and I can't seem to get:
I have 2 tables, one with keys and key_id's called 'key', the other with key_id's and info_id's called 'comb'.
no lets presumme the following filling of those tables:
key:
key_id keys
1 test1
2 test2
3 test3
4 test4
comb:
key_id info_id
1 1
1 2
2 1
2 3
3 3
3 1
(there is a third table (info) which contains info_id and info, this one is not that important now)
Now when I search on 1 key, say test1 the query should return all info_id's which contain key_id 1, so that would be: 1, 2.
Now if I refine the the search haveing it like: test1 test2 it should return all info_id's containing test1 and in that result select all the info_id's with also test2.
So far with all the help from Vincent I haven't been able to get this result, it only gets all the info_id's where either test1 or test2 is present....
I am kinda lost now....
Here is one more try to give the full picture on what I am trying to do and I can't seem to get:
I have 2 tables, one with keys and key_id's called 'key', the other with key_id's and info_id's called 'comb'.
no lets presumme the following filling of those tables:
key:
key_id keys
1 test1
2 test2
3 test3
4 test4
comb:
key_id info_id
1 1
1 2
2 1
2 3
3 3
3 1
(there is a third table (info) which contains info_id and info, this one is not that important now)
Now when I search on 1 key, say test1 the query should return all info_id's which contain key_id 1, so that would be: 1, 2.
Now if I refine the the search haveing it like: test1 test2 it should return all info_id's containing test1 and in that result select all the info_id's with also test2.
So far with all the help from Vincent I haven't been able to get this result, it only gets all the info_id's where either test1 or test2 is present....
I am kinda lost now....