probably easy solved problem with list-menu?

[perik78]

Hi!

Im using a forum that is called e107 which is build in php.
Im editing this plugin:
http://plugins.keal.me.uk/plugins/recipe_menu/recipes.php

and run into a problem.
In the "Select Category" (see picture below) I succeded to list all the posts from a single author instead of categories by editing this code:

           $recipemenu_selcat = '
			<select class="tbox" name="recipemenu_select" onchange="this.form.submit()">
				<option value="" >' . RCPEMENU_111 . '</option>';
            if ($sql->db_Select('recipemenu_category', '*', ' order by recipe_category_name', 'nowhere', false))
            {
                while ($recipemenu_row = $sql->db_Fetch())
                {
                    extract($recipemenu_row);
                    $recipemenu_selcat .= "<option value='{$recipe_category_id}' ";
                    if ($recipe_category_id == $recipemenu_recipecat)
                    {
                        $recipemenu_selcat .= ' selected="selected"';
                        $recipe_catdesc = $recipe_category_description;
                        $recipemenu_catname = $recipe_category_name;
                        $recipemenu_where = "recipe_category='$recipemenu_recipecat'";
                        if ($recipemenu_row['recipe_category_icon'] && file_exists('images/caticons/' . $recipemenu_row['recipe_category_icon']))
                        {
                            $recipemenu_caticon = '<img src="images/caticons/' . $recipemenu_row['recipe_category_icon'] . '" style="border:0;" alt="" />';
                        }
                    }
                    $recipemenu_selcat .= '>' . $tp->toFORM($recipe_category_name) . '</option>';
                } // while
            }
            else
            {
                $recipemenu_selcat .= '<option value="0">' . RCPEMENU_4 . '</option>';
            }
            $recipemenu_selcat .= '</select>';

into:

// START CODE
            $recipemenu_selcat = '
			<select class="tbox" name="recipemenu_select" onchange="this.form.submit()">
				<option value="" >' . RCPEMENU_111 . '</option>';
            if ($sql->db_Select('recipemenu_recipes', '*', ' order by recipe_author', 'nowhere', false))
            {
                while ($recipemenu_row = $sql->db_Fetch())
                {
                    extract($recipemenu_row);
                    $recipemenu_selcat .= "<option value='{$recipe_author}' ";
                    if ($recipe_author == $recipemenu_recipecat)
                    {
                        $recipemenu_selcat .= ' selected="selected"';
                        $recipe_catdesc = $recipe_author_description;
                        $recipemenu_catname = $recipe_author;
                        $recipemenu_where = "recipe_author='$recipemenu_recipecat'";
                        if ($recipemenu_row['recipe_author_icon'] && file_exists('images/caticons/' . $recipemenu_row['recipe_author_icon']))
                        {
                            $recipemenu_caticon = '<img src="images/caticons/' . $recipemenu_row['recipe_author_icon'] . '" style="border:0;" alt="" />';
                        }
                    }
					$recipemenu_bortmedborjan = explode(".", $recipemenu_row['recipe_author'], 2);
					$recipemenu_lank = $tp->toFORM($recipemenu_bortmedborjan[1], false);
                    $recipemenu_selcat .= '>' . $recipemenu_lank . '</option>';
                } // while
            }
            else
            {
                $projectmenu_selcat .= '<option value="0">' . RCPEMENU_4 . '</option>';
            }
            $projectmenu_selcat .= '</select>';
// END CODE   

what i basically did was to replace the recipe_category with recipe_author.

The function works but the problem is that now I get a list that looks like this:

thanks a lot! any help what so ever would be very much apreciated!!!

[halojoy]

"SELECT DISTINCT author FROM table"

DISTINCT will take each author only 1 time
in your example will return 2 results:
Katapult
per

SQL Tutorial with examples: http://www.tizag.com/sqlTutorial/sqldistinct.php

[perik78]

solved it by changing:

    if ($sql->db_Select('projectmenu_projects', '*', ' order by project_author', 'nowhere', false))

to:

            if ($sql->db_Select('projectmenu_projects', 'project_author', ' GROUP BY project_author', 'nowhere', false))

The whole code is now:

//FROM
            $projectmenu_selcat = '
			<select class="tbox" name="projectmenu_select" onchange="this.form.submit()">
				<option value="" >' . RCPEMENU_111 . '</option>';
//              if ($sql->db_Select('projectmenu_projects', '*', ' order by project_author', 'nowhere', false))

        if ($sql->db_Select('projectmenu_projects', 'project_author', ' GROUP BY project_author', 'nowhere', false))
        {
            while ($projectmenu_row = $sql->db_Fetch())
            {
                extract($projectmenu_row);
                $projectmenu_selcat .= "<option value='{$project_author}' ";
                if ($project_author == $projectmenu_projectcat)
                {
                    $projectmenu_selcat .= ' selected="selected"';
                    $projectmenu_catname = $project_author;
                    $projectmenu_where = "project_author='$projectmenu_projectcat'";
//            	if ($projectmenu_row['project_author_icon'] && file_exists('images/caticons/' . $projectmenu_row['project_author_icon']))
//            	{
//            	$projectmenu_caticon = '<img src="images/caticons/' . $projectmenu_row['project_author_icon'] . '" style="border:0;" alt="" />';
//          	}
                    }
					$projectmenu_bortmedborjan = explode(".", $projectmenu_row['project_author'], 2);
//					$projectmenu_lank = $tp->toFORM($projectmenu_bortmedborjan[1], false);
                    $projectmenu_selcat .= '>' . $tp->toFORM($projectmenu_bortmedborjan[1], false) . '</option>';
                } // while
            }
// TO

But now I would like to change so I get links instead of <option> menu so it displays like below:

Katapult <a href LINK THAT LISTS ALL THE PROJECTS OF THAT USER>
Per <a href LINK THAT LISTS ALL THE PROJECTS OF THAT USER>
User3 <a href LINK THAT LISTS ALL THE PROJECTS OF THAT USER>
User4 <a href LINK THAT LISTS ALL THE PROJECTS OF THAT USER>
and so on ...

so links instead of the users that are displayed in option menu "Show by member:":

any tips how?

By the way in the picture of the phpmyadmin there have been some small namechangnings so just imagine that everywhere it says project there shall be recipe instead.

Thanks a lot!

Per