Gossamer Forum
(Advanced Search)
for
Mar 17, 2002, 2:01 PM
Paul
Veteran (19537 posts)
Mar 17, 2002, 2:01 PM
Views: 4280
Shortcut
Quote Reply
Re: [Alex] GROUP BY In reply to
Well Im hoping you can help solve the select problem as it is only selecting one link currently.

I'm not sure I have this right. I have a new table...mylinks:

UserID LinkID

.....so first I select all "favorites" for the logged in user and store all the link id's in @list, then Im trying to select the links from the links table using IN but group them by the category they reside in, in the directory.

Last edited by:

Paul: Mar 17, 2002, 2:02 PM
Subject Author Views Date
Thread GROUP BY Paul 4431 Mar 17, 2002, 4:57 AM
Thread Re: [Paul] GROUP BY 		Paul 4310 Mar 17, 2002, 5:08 AM
Post Re: [Paul] GROUP BY 		pugdog 4278 Mar 17, 2002, 9:20 AM
Thread Re: [Paul] GROUP BY 		Alex 4318 Mar 17, 2002, 1:58 PM
Thread Re: [Alex] GROUP BY 		Paul 4280 Mar 17, 2002, 2:01 PM
Thread Re: [Paul] GROUP BY 		Alex 4293 Mar 17, 2002, 2:08 PM
Post Re: [Alex] GROUP BY 		Paul 4247 Mar 17, 2002, 2:11 PM
Post Re: [Alex] GROUP BY 		Paul 4260 Mar 18, 2002, 3:31 AM
Post Re: [Alex] GROUP BY 		Paul 4252 Mar 19, 2002, 4:31 AM
Thread Re: [Paul] GROUP BY 		Alex 4298 Mar 17, 2002, 1:53 PM
Post Re: [Alex] GROUP BY 		Paul 4311 Mar 17, 2002, 1:56 PM