stephan.gerlach
04-04-2007, 04:25 AM
I have the following problem and i wonder if I can solve it with SQL or if I need a server side script (php). Oh yes i forgot to say I am working with php and MySQL.
I have a field in a table which has a number of id's in it for example
|5||43||54|
or
|90||76||65||4||56|
or it could be empty.
Each of the ID's relate to the id coloumn of a different table.
Can I create some kind of join so that i can query everything in one query ?
I have a field in a table which has a number of id's in it for example
|5||43||54|
or
|90||76||65||4||56|
or it could be empty.
Each of the ID's relate to the id coloumn of a different table.
Can I create some kind of join so that i can query everything in one query ?