if i understand you correctly then this should give valid interests of a
user:
SELECT DISTINCT
InterestsList.SubID
FROM
InterestsIndex INNER JOIN InterestList
ON InterestIndex.InterestID=InterestList.ID
WHERE
InterestIndex.UserID='1' AND
InterestList.Valid='1'
and if the chosen interest is '3' then valid subinterests are:
SELECT
InterestsList.ID, InterestsList.SubID, InterestsList.Interest,
InterestsList.Valid
FROM
InterestsIndex INNER JOIN InterestList
ON InterestIndex.InterestID=InterestList.ID
WHERE
InterestIndex.UserID='1' AND
InterestList.SubID='3' AND
InterestList.Valid='1'
regds,
-----Original Message-----
From: Zydox [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 15, 2003 09:48
To: [EMAIL PROTECTED]
Subject: SQL Query
I have a problem writing a query that can select a Interest for a specific
user... There are tvo tables, IList and IIndex...
IList contains this :
ID SubID Interest Valid
Edit Delete 1 0 Datorer 0
Edit Delete 2 1 Spel 0
Edit Delete 3 2 Strategi 0
Edit Delete 4 3 Star Craft 1
Edit Delete 5 3 Star Wars: Gallactic Battelinggrounds 1
Edit Delete 6 2 Shoot-Em-Up 0
Edit Delete 7 6 Half-Life 0
Edit Delete 8 7 Team Fortress 1
Edit Delete 9 7 Counter-Strike 1
And IIndex contains a UserID And InterestID... this query :
"SELECT DISTINCTROW InterestsList.ID, InterestsList.SubID,
InterestsList.Interest, InterestsList.Valid FROM InterestsList AS II RIGHT
JOIN InterestsList ON InterestsList.ID=II.SubID LEFT JOIN InterestsIndex ON
InterestsList.ID=InterestsIndex.InterestID AND InterestsIndex.UserID='1'"
Selects all rows from IList... even if there Is'nt any instans in IIndex...
this thougt is that a User can choose a "Valid" Interest and then the query
should select all SubInterests... anyone know how to do that ?
// Regards Zydox
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
