Hi,
since a fiew days i'm thinking of using a mySQL-Query to get links from one subcategory displayed - anything like the following (i know that this wouldn't work!) :
SELECT * FROM Links,Category WHERE fatherID='55'
Links SQL is saving the Relationship between an entry and the choosen category in the table 'CatLinks' - there's the actual category for an entry saved - that's my knowhow til yet ;)
I know how to create queries for one table, but how do i create a query in relationship to other tables?
It wouldbe great if anyone could post a sample, where i could learn from.
Thanks!
since a fiew days i'm thinking of using a mySQL-Query to get links from one subcategory displayed - anything like the following (i know that this wouldn't work!) :
SELECT * FROM Links,Category WHERE fatherID='55'
Links SQL is saving the Relationship between an entry and the choosen category in the table 'CatLinks' - there's the actual category for an entry saved - that's my knowhow til yet ;)
I know how to create queries for one table, but how do i create a query in relationship to other tables?
It wouldbe great if anyone could post a sample, where i could learn from.
Thanks!