Category dropdown menu?

[sunstardude]

What's the best way to make a dropdown menu that auto populates with the categories from the database, and also if possible maintain via a cookie or user-login whatever category user last selected. Any such code already made for pligg 9.5/6??

[allenp]

To make a pulldown with the categories use the following php:

         $catsql = mysql_query("SELECT category_id, category_name FROM " . table_categories . " WHERE category_lang='$dblang' ORDER BY category_name ASC");
    $categories = array();
    while ($rows = mysql_fetch_array ($catsql, MYSQL_ASSOC)) array_push ($categories, $rows);
    $main_smarty->assign('categories', $categories);

    include_once(mnminclude.'dbtree.php');
    $array = tree_to_array(0, table_categories, FALSE);
    $main_smarty->assign('lastspacer', 0);
    $main_smarty->assign('cat_array', $array); 
  

And this in the template:

             <select name="category">
            {section name=thecat loop=$cat_array}
               <option value = "{$cat_array[thecat].auto_id}">
                  {if $cat_array[thecat].spacercount lt $lastspacer}{$cat_array[thecat].spacerdiff|repeat_count:''}{/if}
                  {if $cat_array[thecat].spacercount gt $lastspacer}{/if}
                  {$cat_array[thecat].spacercount|repeat_count:'&nbsp;&nbsp;&nbsp;'}
                  {$cat_array[thecat].name} 
                  &nbsp;&nbsp;&nbsp;       
                  {assign var=lastspacer value=$cat_array[thecat].spacercount}
              </option>
            {/section}
        </select> 
  

This is in submit.php and submit_step_2.tpl in the yget template if you want to see it in use.

Patrick

[sunstardude]

Thanks for the code, Patrick. But where do I put the PHP code? When I put it into the template with the other code it displays on the webpage as if it has not been processed.

Also, how do I make the dropdown menu go to selected category upon selection.. without having to hit a "submit" button?