Drop Down List with Alphabetical list of Stories

[kanedaguy]

Hello Forum Gods

Do you think this is possible to be done?
Create a drop down list enumerated with the list of stories in the system (sorted alphabetically).

Thank you.

[savant]

yes this can be done.

[kanedaguy]

Ok, and can you help me? Or if its on some tutorial site, guide me?

[savant]

you can do a simple sql query to get the data

select * from pligg_links order by links_title ASC;

and then get the link_title and populate a drop down box.

references:
http://dev.mysql.com/doc/refman/5.0/en/select.html
http://www.freewebmasterhelp.com/tutorials/phpmysql
http://www.plus2net.com/php_tutorial..._down_list.php

[kanedaguy]

this is a bit lame, but could you possibly post some example code?

[savant]

ok here's some code.

This was put inside the do_sidebar function in htm1.php

         //this gets all the stories
    $storySql = "SELECT link_id, link_title from " . table_links . " where link_status = 'published' or link_status = 'queued';";
    $stories = $db->get_results($storySql);
    //store the id and title in an array
    $storylist = array();
    foreach ( $stories as $story )
        $storylist[] = array($story->link_id,$story->link_title);
    //pass the array to the template
    $var_smarty->assign('dropdownStories',$storylist); 
  

If you are putting it somewhere else it can be $main_smarty or $smarty.

And this bit puts the items in a drop down box.
I put this in sidebar.tpl

 <li>
    <div class="box" id="dropdownstory">
        <select>
            {foreach from=$dropdownStories value=dropdownstory}
            <option value="{$dropdownstory[0]}">{$dropdownstory[1]}</option>
            {/foreach}
        </select>
    </div>
</li> 
  

[kanedaguy]

wow this is great!!!

Thank you.

Now I have to get it sorted alphabetically and include links so when somebody chooses a movie it loads that page.

[kanedaguy]

 //this gets all the stories
    $storySql = "SELECT link_id, link_title from " . table_links . " where link_status = 'published' or link_status = 'queued' ORDER BY link_title ASC;";
    $stories = $db->get_results($storySql);
    //store the id and title in an array
    $storylist = array();
    $storylist[] = array(0, "Select your story");
    foreach ( $stories as $story )
        $storylist[] = array($story->link_id,$story->link_title);
    //pass the array to the template
    $var_smarty->assign('dropdownStories',$storylist); 
  

Hello
Thank you for that.

I got the title of the drop-down list (Select your story), and I got the list sorted.

But I am trying to make it so that when the user selects the story, the page goes to that link.

Grateful for any pointers.

Thank you.

[kanedaguy]

Hello,
This is what I came up with another guy on some web forum.
On the template side, I want to make it so that when the person chooses the story, the page reloads with that link.

Any ideas please?
Thank you.

 if (isset($_GET['dropdownStories']))
{
    $id = (int) $_GET['dropdownStories'];
    $query = "SELECT link_url FROM " . table_links . " WHERE link_id = $id";
    $result = mysql_query($query) or die(mysql_error());
    if (mysql_num_rows($result))
    {
        list($link_url) = mysql_fetch_array($result);
        header ('Location: '.$link_url);
        exit();
    }
    else
    {
        echo 'invalid selection. Try again';
    }   
}
 
//this gets all the stories
    $storySql = "SELECT link_id, link_title from " . table_links . " where link_status = 'published' or link_status = 'queued' ORDER BY link_title ASC;";
    $stories = $db->get_results($storySql);
    //store the id and title in an array
    $storylist = array();
    $storylist[] = array(0, "Select your story");
    foreach ( $stories as $story )
        $storylist[] = array($story->link_id,$story->link_title);
    //pass the array to the template
    $var_smarty->assign('dropdownStories',$storylist); 
  

[savant]

I'm not sure of the list. because there only should be one link with one id.

 if (mysql_num_rows($result))
    {
        $row = mysql_fetch_assoc($result);
        $link_url = $row['link_url'];
        header ('Location: '.$link_url);
        exit();
    }