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 Link to comment https://forums.phpfreaks.com/topic/184056-best-match/ Share on other sites More sharing options...
The Little Guy Posted December 5, 2009 Author Share Posted December 5, 2009 any suggestions? Link to comment https://forums.phpfreaks.com/topic/184056-best-match/#findComment-972001 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? Link to comment https://forums.phpfreaks.com/topic/184056-best-match/#findComment-975780 Share on other sites More sharing options...
emopoops Posted December 12, 2009 Share Posted December 12, 2009 use mysql LIKE Link to comment https://forums.phpfreaks.com/topic/184056-best-match/#findComment-975920 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.