July 29th, 2000, 09:07 PM
I've been trying to display multiple text in a page using the MySQL, this the one i'm using right now:
select * from coder where user_id='$profile' group by user_id order by title
Lets say I have 3 records in the coder table. two with same user_id since I want both titles from this user to be shown on same page.
When I try the code above it only shows the first record of this user. Anyone know what i'm doing wrong?
July 30th, 2000, 07:59 AM
Get rid of the group by clause. Since you aren't using any functions that requires the records to be grouped it isn't doing anything... except causing you to only get one record per user_id.
July 30th, 2000, 10:24 AM
I removed the 'group by user_id' part but it still only show the first record.
Is it something else I should put there too?