hi i have mp3 search engine which is create duplicate recent searches value in database which is not good for seo ex: if i search song like "we cant stop mp3" than it will show recent searches and also save in database than if any other user search same keyword like "we cant stop mp3" than it will also save in recent searches and database which is duplicate i want to get rid from this issue and i want to fix this issue please any body help me i ll pay you thanks
Well... if you don't care about the db-storage, you can group by search_value or something when pulling the data from the database, hence removing duplicate entries- or you can check to see if the search is already in the database when a user searches, and if it is, don't add it. However, shouldn't recent searches always just show the recent searches, regardless of if it has been searched for before? Hence you should also have a time-check, to see if the search is there, and if it is, when it was last used - and if it's not in the last 10, or 20, or whatever number, add it again (maybe deleting the previous entry in the process)
but i fix this issue because there is many duplication in database and every user if he search same song 10time it will add same stings in database which is duplicate and bad for seo i want to get rid from it yes i agree it will 1st check if no search in db it will add otherwise 1st search in db how i fix this issue ?