Gossamer Forum
Home : Products : Gossamer Links : Discussions :

MySQL-Query for showing links from one category?

Quote Reply
MySQL-Query for showing links from one category?
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!


Subject Author Views Date
Thread MySQL-Query for showing links from one category? Chef 924 Jul 3, 2001, 9:23 AM
Post Re: MySQL-Query for showing links from one category?
Stealth 886 Jul 3, 2001, 11:35 AM