SQL query for frequency-related results

ire · November 17th, 2008, 05:27 AM

Hi guys,
I need some assistance please: how do I structure a SQL command to return frequency-related results from a database. For example, if I wanted the query to return the top 5 entries in a table within specified dates. By top 5 (N), I mean the records (values) in a given table that have occurred the most within that table. Perhaps, to help you help me, if user requests for a product were entered into a table, and I wanted to find out the most requested product in the month of May or within the last 6 months, how will the SQL query be please? Thanks.

ire · November 17th, 2008, 07:40 AM

problem solved - solution available at http://groups.google.co.uk/group/com...e143e44?hl=en#

zeronexxx · December 23rd, 2008, 09:24 PM

Quote:

Originally Posted by ire

Hi guys,
I need some assistance please: how do I structure a SQL command to return frequency-related results from a database. For example, if I wanted the query to return the top 5 entries in a table within specified dates. By top 5 (N), I mean the records (values) in a given table that have occurred the most within that table. Perhaps, to help you help me, if user requests for a product were entered into a table, and I wanted to find out the most requested product in the month of May or within the last 6 months, how will the SQL query be please? Thanks.

i had to go and find the code from my website here is the code that does what you looking for

PHP Code:


			
$query = "SELECT SQL_CALC_FOUND_ROWS *,MATCH (title,story.desc) AGAINST ('$keyphrase') as rele FROM story WHERE MATCH (title,story.desc) AGAINST ('$keyphrase') ORDER BY rele DESC LIMIT ".(($page-1)*($resultPerPage)).",".($resultPerPage);

$result = mysql_query($query) or die($query);

in the above query by "rele" i mean relevance or frequency.

thanks

Old Pedant · December 24th, 2008, 10:40 PM

Why do you give an answer
(a) a month and a half late and
(b) when the original poster says he has already solved the problem???

What was the point?

zeronexxx · December 25th, 2008, 04:51 PM

hi Old Pedant,

sorry actually i did not really check the time and did not read the other replies, i just tried to answer the question.

Thanks