[PHP-DB] Return Results in Categories - like CNET

I would like to allow articles to be searched and returned in grouped categories - similar to cnet.com See example here: http://cnet.search.com/search?timeout=3q=php Grouping is not a problem - but it becomes a problem when there are thousands of results and I only want to display the first

Re: [PHP-DB] Return Results in Categories - like CNET

If your articles are in an SQL database uses the LIMIT clause on your SQL statement. Adam On Fri, 16 Aug 2002, olinux wrote: I would like to allow articles to be searched and returned in grouped categories - similar to cnet.com See example here:

Re: [PHP-DB] Return Results in Categories - like CNET

Thank you but this is not what I am looking for. LIMIT will limit the overall results but I need to limit the number of matches to each category 'type' example: for the data below there may be 1000 news story matches - I want to return the user the top 5 news stories - the top 5 feature matches

Re: [PHP-DB] Return Results in Categories - like CNET

I am just trying to return a few results from each category. like this: http://cnet.search.com/search?timeout=3q=php sql query example: SELECT id, article_date, category, region, title FROM articles WHERE MATCH (title,article) AGAINST ('$search_word'); There are 20 possible categories that may