I have this table that keps a log
of the user search activity. For ex, on the site
search page of the site, if a user searches for
a keyword "test", it gets stored on the database table
along with other details like the
username, date/time, search category and the results
found.
The columns are
DateTime, UserName, SearchKeyword, SearchCategory and
ResultsFound
I am displaying this information in a report to the
admin user.
It currently displays all the information using a
simple select statement. I want to
display all search keywords a user has searched for in
one row.
So instead of displaying the information like this
09/09/2003 17:41:26 powerpoint testUser1
09/09/2003 18:42:26 word testUser1
09/09/2003 19:44:26 excel testUser1
09/09/2003 20:45:26 notepad testUser1
I want to display it like this
In the last 7 days
powerpoint,word,excel,notepadtestUser1
Can somebody show me how to do this please
Best Regards
Allan
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
