Right i have a problem, i am using SQL's fulltext search to search the database and return any products, so far i have the fulltext search working with one of the fields (catagory) this is the film catagory.
I want to be able to search for a specific dvd title, but in order fulltext searching to work, there must be atleast 2 or more records of the one you are searching for, for it to return results.
I.E catagory is fine because i could have multiple entries with the catagory as "Comedy"
but if im searching for the title of a film, this wont work because obviously im only going to have 1 entry per title.
How would i get around this?? if i exclude the title field from being fulltext i get this error when trying to search.
Can't find FULLTEXT index matching the column list
I want to be able to search for a specific dvd title, but in order fulltext searching to work, there must be atleast 2 or more records of the one you are searching for, for it to return results.
I.E catagory is fine because i could have multiple entries with the catagory as "Comedy"
but if im searching for the title of a film, this wont work because obviously im only going to have 1 entry per title.
How would i get around this?? if i exclude the title field from being fulltext i get this error when trying to search.
Can't find FULLTEXT index matching the column list