Sort ASC

[andy1989]

Hey
I am working on a tube site and I made a tags page showing all tags from all videos and their count..
The only problem is when I made my query I added "ORDER BY keywords ASC"
and so I got it sorted like: "amp, guitar, music" "guitar, jimi hendrix" "music, video, acoustic"

so once I added "preg_split" I have it like: amp, guitar, music, jimi hendrix, video, acoustic

so now I need to order it once more.
I tried using sort() and asort() but NO LUCK!

this is my code:

<?
 $column=0;
$result = mysql_query("SELECT keywords FROM content ORDER BY keywords ASC")
        or die(mysql_error());
$arr_keywords="";

while ($row = mysql_fetch_array($result)) {

$arr_keywords.= $row['keywords']." "; // make a big string from each post of the keywords
    $arr_keywords = preg_replace('/\.[^.]+$/','',$arr_keywords);
    $arr_keywords = strtolower($arr_keywords);

}

$tag = preg_split("/[\s,]+/", $arr_keywords); //make array of your keywords, splitting based on commas or white spaces (returns, space, tab, etc.)

foreach($tag as $keyword)
{

//loop through the list of all the words and build an array of them counting the number
//of times they occur so the final array will have a keyword list and a count.
if(!isset($list[$keyword])) $list[$keyword]=0; // initialize value
$list[$keyword]++; // increment count for that keyword

}
// remove words you don't care about
if(isset($list["and"])) unset($list["and"]);
if(isset($list["or"])) unset($list["or"]);
if(isset($list["the"])) unset($list["the"]); // etc....


foreach($list as $keyword=>$count){

    $column=$column+1;
    $rest = $column % 620;
     $link='/search/'.$keyword.'/page1.html';


    if ($rest == 1) { echo '<div style="width:220px; float:left; margin-left:15px; line-height:17px;">'; }

    asort($keyword);
?>

<a href="<? echo $link; ?>" style="text-decoration:none;"><? echo $keyword. " (".$count.")<br>";  ?>

    <?      if ($rest == 0) { echo '</div>'; } }?>

Thanks in advance! 🙂

[bradgrafelman]

For one, this:

foreach($tag as $keyword) 
{ 

//loop through the list of all the words and build an array of them counting the number 
//of times they occur so the final array will have a keyword list and a count. 
if(!isset($list[$keyword])) $list[$keyword]=0; // initialize value 
$list[$keyword]++; // increment count for that keyword 

} 

could be replaced by this:

$list = array_count_values($tag);

(see the manual page for [man]array_count_values/man to learn more).

For another, have you used [man]print_r/man to examine your final array, just to be sure it is what you expect it to be?

Finally, which array are you wanting to sort? Can you show us what you tried?

EDIT: Oh, now I see the asort()... I missed it because it's definitely not in the right place. 😉

Take a look at the manual for [man]asort/man and see what parameters it expects, then look at what you're passing it. You're supposed to simply pass asort() the array to be sorted, yet instead you're repeatedly calling it inside a loop... on $keyword, which is just going to be a scalar (e.g. each key of the array).

[andy1989]

Thanks a lot man

I got it to work!!! 🙂

One more question..
is there a way I can make it go in rows instead of columns?

now it's like:

apple coke pear
banana dish pork
cheese egg

I want it to show like:

apple banana cheese
coke dish egg
pear pork

thanks