Welcome Visitor, Please Login or Register Now Friday, April 26, 2024 11:42 PM 
Forums Index > Mewsoft Products > Auctionawy > Search queries
New Topic   New Reply
Search for:
Author Message
upperbid upperbid's personal page
Registered Member
Posts: 50 Display member's posts
Joined: 07-15-05 08:29 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Search queries Edit Delete Reply with quote Quote
First Post Posted on: 07-21-11 07:10 AM next post first post
Hi Ahmed,\ \ I need to know if there is a file that keeps track of search queries so I can see what people are searching for. If there is, can you let me know where it is. Thanks.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-26-24 11:42 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Search queries Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 07-21-11 08:10 AM next post previous post

All search queries already saved into sql table called "Terms", you can access it from scripts or from admin->Database & SQL Manager->SQL Commander and use this sql command in the text box:

SELECT DISTINCT Term FROM Terms ORDER BY Term ASC, Time DESC

This will query the unique search terms used.


Mewsoft Support
www.mewsoft.com

upperbid upperbid's personal page
Registered Member
Posts: 50 Display member's posts
Joined: 07-15-05 08:29 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Search queries Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 07-22-11 07:40 AM last post previous post
Worked great. Thanks.
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print