I need help grouping and sorting

[greg]

Hello everyone,

 

Could be possible someone help me on this code please?

 

I need to group and sort $search_query. They are the keywords extracted from $_SERVER[HTTP_REFERER] (referer in the query).

 

Thank you in advance.

 

 

$query = ("SELECT referer, browser_ip, date, customers_id, counter, browser_id, browser_language FROM visitors WHERE SUBSTRING(browser_language,1,1) != '[' ORDER by date DESC");
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {

$referer = $row[0];
IF($referer)
{
    PREG_MATCH("/[\&\?]q=([^&]*)/", $referer, $matches);
        $search_query = RAWURLDECODE($matches[1]);
        $search_query = STR_REPLACE("+", " ", $search_query);
}

........................

[btherl]

By "group and sort" do you mean count how many times each $search_query appears and put them in descending order?

[greg]

Yes, I need something like this:

 

Apple store (5)

Boy t-shirt (56)

Girls stuff (45)

Php code (5)

Windows mobile (1)

 

Where the words are the keywords and the numbers is the count.

 

Thank you!

[btherl]

Ok, sorted by keyword.  You could do this:

 

$keywords = array();
while ($row = mysql_fetch_array($result)) {

  $referer = $row[0];
  IF($referer)
  {
    PREG_MATCH("/[\&\?]q=([^&]*)/", $referer, $matches);
        $search_query = RAWURLDECODE($matches[1]);
        $search_query = STR_REPLACE("+", " ", $search_query);
        $keywords[$search_query]++;
  }
}
ksort($keywords);
foreach ($keywords as $k => $c) {
  print "$k ($c)<br>";
}

 

You might also want to use strtolower() on the keywords if they don't already have standard capitalization.

[greg]

This is exactly what I needed! - Thank you for your help.