Jump Menu

[Blue Moose Aaron]

I want to create a jump menu that will display the id and name of all the records in a certain table. I figured out how to do it with my individual php file, but now Im trying to get it to work with vB and templates.

Any ideas?

[Revan]

This will most likely not work, but you can try this:

In your vb php file put summit like this:

PHP Code:

$options .= "<option value='".$row[contents]."'>".$row[contents]."</option>";
$options .= "<option value='".$row[contents2]."'>".$row[contents2]."</option>"; 


Then in your template put summit like this:

PHP Code:

<select name="selection">$options</select> 


hopefully ye get the picture.
if not, then in plain words if you put .= infront of a variable you add it to the var instead of overwriting current value.

Hopefully this wasnt just me talking bs ?

[Blue Moose Aaron]

I originally had it set up like this and it displays all the records (http://www.thekryptonian.com/smallville.php)

PHP Code:

<select onChange="location=options[selectedIndex].value;">
                    <option selected> Choose an Ep  </option>
                              <?
        $result = mysql_query("SELECT * FROM smallville_episode_guide ORDER BY id ASC",$db);
        $php_self = $_SERVER['PHP_SELF'];
        while ($myrow = mysql_fetch_array($result)) {
printf("<option value=\"%s?action=episodeguide&episode=%s\">---%s - %s</option> \n", $php_self, $myrow['id'], $myrow['id'], $myrow['episode_name']);
        }
        
        
      ?></select>

I just need to find out how to make that code work with vB cause its not!

[Revan]

If it works in another php file then it works with vB as well, so your problem is to ave it echo in the template.
maybe summit like this:

In your template:

PHP Code:

<select onChange="location=options[selectedIndex].value;">
                    <option selected> Choose an Ep  </option>
                    $options                   
</select> 


In your php file:

PHP Code:

        $result = mysql_query("SELECT * FROM smallville_episode_guide ORDER BY id ASC",$db);
        $php_self = $_SERVER['PHP_SELF'];
        while ($myrow = mysql_fetch_array($result)) {
$options = "<option value='%s?action=episodeguide&episode=%s'>---%s - %s</option> \n", $php_self, $myrow['id'], $myrow['id'], $myrow['episode_name'];
        } 


Basically just stick all your episode query results into a variable, and have this echo in the template....

[Blue Moose Aaron]

I get an error with that The , coma on this line gets me "<option value='%s?action=episodeguide&episode=%s'>---%s - %s</option> \n", $php_self, $myrow['id'], $myrow['id'], $myrow['episode_name'];

[Revan]

Hm well then just look at other hacks/vb itself and see how they do it.

Take a look at the forumjump stuff for example, this is similar to your issue in the way that its a <select>, and its <option>'s is dynamic

[Blue Moose Aaron]

I am, but I'm having a time finding where forumjumpbits is...

Thanks for your help so far, maybe someone will come along with some idea.

On a positive note I have got it to display, the only problem left is that it is only diplaying one record rather than all of them.

[Revan]

Did you try the .= to print all the results into the variable?
This SHOULD work because its the same concept that saved my ass in the RPG convertion

[AN-net]

you should not hardcode such things

here is the html:

<select onChange="location=options[selectedIndex].value;"> 
                    <option selected> Choose an Ep  </option> 
                    $options                    
</select>

here is php

PHP Code:

eval('$options .= "' . fetch_template('templatename') . '";'); 


in that template put:

<option value="$variable1">$variable2</option>

[Blue Moose Aaron]

Well that worked, but its only displaying one record rather than all of them. Any suggestions?