The Little Guy Posted December 5, 2009 Share Posted December 5, 2009 I have a input box, and a user can input a question, for example lets say he/she inputs: "How many feet are in a mile?" I then have a database with common phrases, that match another table with a category I would like to search the database for which phrase this would best fit. currently the table has these in one field, and in another field has "1" which is a foreign key to the primary key on the other table which has a value "math" in that table. - how many - how much - total cost - quantity The table will expand as my application expands. so what is my best method to take that whole query and search the database to see what method I should use? Using the query above the database should return that "how many" is the best fit for this question, and that is related to a math question. Let me know if I confused anyone Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted December 5, 2009 Author Share Posted December 5, 2009 any suggestions? Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted December 12, 2009 Author Share Posted December 12, 2009 I am still stuck on this, does anyone have any suggestions? Quote Link to comment Share on other sites More sharing options...
emopoops Posted December 12, 2009 Share Posted December 12, 2009 use mysql LIKE Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.