[tom]

hey guys! i have a very small CMS right now on my site.
it is working great, but i want to change the way the menu is displayed. right now it shows just text links, but i want to replace the text links with a dropdown menu.

this is the code i use at the moment to show the menu.

PHP Code:

<?php

 $result = mysql_query("SELECT * FROM menu ORDER BY 'sort' ASC");

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





/* display menu items  */

echo "<a href=\"index.php?m=$row[mid]&s=0\">$row[menu]</a><br>";

?>

this generates something like:
Home
Downloads
Info

but now i want it to show these things in the dropdown menu.

how do i edit the php code i pasted here, to show my items in a dropdown menu?

thanks in advance!

[ChristGuy]

Greetingz...

To get the drop down to display:

PHP Code:

<SELECT>

<?php

  $result = mysql_query("SELECT * FROM menu ORDER BY 'sort' ASC");



  while($row = mysql_fetch_array($result))

  {

    /* display menu items  */

    echo '<OPTION VALUE="' . $row[mid] . '">' . $row[menu] . "</OPTION>";

  }

?>

</SELECT>

To make the menu jump you'll need to add some JavaScript:

PHP Code:

<SCRIPT LANGUAGE="JavaScript">

  function jumptourl()

  {

    window.location = 'index.php?m=' + frmMenu.MenuItem + '&s=0';

  }

</SCRIPT>

<FORM NAME="frmMenu" OnSubmit="jumptourl()">

  <SELECT NAME="MenuItem" OnChange="frmMenu.submit()">

  ...

  </SELECT>

</FORM> 

Basically that'll work...
Hope it helps...

[tom]

worked like a charm, although for it to work i had to modify that menu jump code a bit. changed it to this:

PHP Code:

<SCRIPT LANGUAGE="JavaScript">

  function jumptourl()

  {

    window.location = '?m=' + frmMenu.m.Value;

  }

</SCRIPT> 

anyhow, its sorted. thanks!

[ChristGuy]

of cource...
.value

Well... glad it works...

[tom]

me too ;D

[tom]

sorry to bring this thread back up, but i seem to be having a problem

the first item in the generated list doesn't seem to work.
it creates the link correctly, and entering the link in manually in the URL window works fine ofcourse, but when people click it, nothing happens. what's up with this?
the code works fine for all the other options in the select form.. just not the first one.

[tom]

just thought i should add some code for the sake of clarity

here is the javascript that handles the menu jumper:

PHP Code:

<SCRIPT LANGUAGE="JavaScript">

  function navigate()

  {

    window.location.href = 'index.php?m=' + frmMenu.m.Value;

  }

</SCRIPT> 

and this is dropdown itself:

PHP Code:

<FORM NAME="frmMenu" OnSubmit="navigate()">

<SELECT NAME="m" OnChange="frmMenu.submit()">

            <OPTION VALUE="1">home</OPTION>

            <OPTION VALUE="2">option two</OPTION>

            <OPTION VALUE="3">option 3</OPTION>

            <OPTION VALUE="4">updates</OPTION>

</SELECT>

</FORM> 

if anybody could help that'd be real cool..

[ChristGuy]

The reason it doesn't is that javascript doesn't fire the OnChange event for the currebtly selected item...

I normally use something like this...

PHP Code:

<?php

  function drawOption($sDesc, $sValue, $sCurrent);

  {

    $Option = '<OPTION VALUE=' . $sValue;



    if ($sValue == $sCurrent)

    {

      $Option .= ' SELECTED';

    }



    $Option .= '>' . $sDesc . '</OPTION>';



    echo $Option;

  }



  if (ISSet($_REQUEST["m"]))

  {

    $m = $_REQUEST["m"];

  }

  else

  {

    $m = '';

  }



?>

<FORM NAME="frmMenu" OnSubmit="navigate()">

<SELECT NAME="m" OnChange="frmMenu.submit()">

<?php

  if (empty($m))

  {

    drawLink('Links...', '', $m);

  }



  drawLink('Home',       '1', $m);

  drawLink('Option two', '2', $m);

  drawLink('Option 3',   '3', $m);

  drawLink('Updates',    '4', $m);

?>

</SELECT>

</FORM>

of cause you could leave out the (Links...) if your first page is $m=1...

Hope it helps and makes sense...