Hi All,
I have a product to be developed with following main tables in it 1. Question table (Question_ID, Question_Title, Question_Description, Question_Category, Question_creation_date are columns in this table) 2. My web site users can answer each question (Question_ID (foreign key to above table, Question_Answer_ID (primary key to this table), User_Answer_Description, Answered_Date) A Question can hare more than one answer. My requirement: When users does a search I should be able to show the results if that search term exists either in Question Title or Question Description or Question Category or Answer_description I should return the results based on the latest answer or latest question Suppose say if a term matches more than one answer_id BUT question_id is same then I should return only one question though it matches more than one answer_id. This is because I have to show only question in the UI (search results page) with a link to view all Answers for this question After findin the unique question ids from SOLR I need to fetch additional data from the database no of times a question is viewed by users in search results page, no of times a question full_details_page is viewed by the user, no of times a question is appeared in the search_results page ################### Technology: ################### I am building the website using PHP 5 and My SQL 5 DB Please let me know how I can index the data What is the best PHP API I can use to get performance results I may have around 10K users accessing the site at a time -- View this message in context: http://www.nabble.com/SOLR-in-PHP-for-my-web-application-tp21132500p21132500.html Sent from the Solr - User mailing list archive at Nabble.com.
