The result recived from that query is this
ID SubID Interest Valid
Edit Delete 4 3 Star Craft 1
But I want a Query that retrives
"Star Craft", "Strategi", "Spel" and "Datorer"... :/
"Willie G" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Zydox,
>
> Please define 'sub-interest'. I've looked at what Uttam gave you, and it
> looks correct, assuming you want want it limited to the same user. If you
> result should be 'all with Interest = X and Valid = Y", just remove the
> userid from the second query.
>
> SELECT
> InterestsList.ID, InterestsList.SubID, InterestsList.Interest,
> InterestsList.Valid
> FROM InterestsIndex
> INNER JOIN InterestList
> ON InterestIndex.InterestID=InterestList.ID
> WHERE
> InterestList.SubID='3' AND
> InterestList.Valid='1'
>
>
> - Larry
>
> -----Original Message-----
> From: Zydox [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 15, 2003 7:58 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: SQL Query
>
>
> Those querys work... but they don't get all the Sub Interests...
>
> "Uttam" <[EMAIL PROTECTED]> wrote in message
> 97FB62E1E350D511B71F00A0C99D0CC30352D563@MSEXCHANGE">news:97FB62E1E350D511B71F00A0C99D0CC30352D563@MSEXCHANGE...
> > 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
>
>
>
begin 666 fulltext.png
MB5!.1PT*&@H````-24A$4@```#(````4" 8```#/RFZ:````ITE$051XG.V6
MR1& ( P`,4,??"S _JN@`![:"/I"&8X,&L3 N$]0V"1<DS;K+@8`OA:HA:0.
ML,R*]+\V&U5!"/%7Y ++J*M6K:QC#%.1*!#JFG^;G!^4?,2-E"=@G9P)?66J
ML32H6IOX:1*769T.T@GY@[4X97SNS)?SA%1C#X2^@'5R)>49';_<@\GYC7LA
L]LHP@9 ?C1@M]UMQ1:Q]4X-.<2# ?!$>EN\TUU7#&PD`````245.1*Y"8((`
`
end
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
