Welcome to WebmasterWorld Guest from 22.214.171.124
Do I use user submitted tags? Or, would it be better to use a MySQL search script by querying the title of the article that's currently displayed and having the results show up beside it?
Any suggestions? Could anyone recommend some tutorials related to developing something like this?
The articles would be user submitted.. so then I guess I'd have to give users the option to select a category that the article they write falls in. But, the thing is, I'd like to avoid that.. i.e. ideally, I'd be able to categorize the articles seemlesly by the text that they contain.
That's why I was thinking of possibly using the title of the article to search trhough other articles for similar terms and displaying the articles that contain some or all of the terms. Would this be a valid approach or is there a better way to go about it?
similar_text("Hello World","Hello Peter",$percent);
So this would return the level of similarity btween the strings "Hello World" and "Hello Peter". But would I beable to use this to compare strings within a table field?
ie. could I do something like
similar_text(SELECT article1 FROM..,"SELECT articles to compare to FROM...,$percent);
I guess this would require me to loop through all other articles in the column and return them in order of similarity. But, somehow this seems a bit inefficient.. I mean, if there are thousands of articles that this would have to loop through. Any suggestions?