Dynamic Drop Down List <select>

kvarnerexpress

Feb 2 2006, 03:13 PM

Hi,

What I am trying to achieve is when you have a form drop down menu, it displays all the categories from the directory, with all the indentations. Something like when you submit your site to a directory.

Now I've got it almost working, but I can figure out how to indent it. The code below, I've used a spacer gif, but obviously that won't work!

I've had a go at this, as you can see, but that does do the indentations, unless I'm doing something wrong here.

Any help appreciated - thanks.

PHP Code:

CODE

Comment/Reply (w/o sign-up)

Spectre

Feb 3 2006, 07:54 AM

As far as indentation goes, it seems to work fine for me under Opera, FireFox, and Internet Explorer.

I hope you don't mind, but I've 'cleaned up' your function slightly. Note that it is quickly written and untested, and sctructured it in the way which I normally write PHP code, which may be a bit annoying for others. Obviously, you're free to simply discard it.

CODE

<?php

function maketree( $rootcatid, $level ) {

   if( !is_numeric($rootcatid) || !is_numeric($level) ) {
      return;
   }

   $sql = 'SELECT catid, cat_name FROM tbl_name WHERE parentid = ' . $rootcatid . ' ORDER BY cat_name';

   $result = @mysql_query($sql);

   if( !$result || @mysql_num_rows($result) < 1 ) {
      return;
   }

   $level++;

   while( $sql_data = @mysql_fetch_assoc($result) ){
      $db_catid = $sql_data['catid'];
      $db_catname = $sql_data['cat_name'];
      $display = '';
      for( $i=0;$i<($level*2);$i++ ) {
         $display .= ' ';
      }
      $display .= '<option value="' . $db_catid . '">' . $db_catname . '</option>';
      echo "$display\n";
      maketree($db_catid,$level);
   }
   @mysql_free_result($result);
}

?>

Comment/Reply (w/o sign-up)

silentwind

Feb 3 2006, 10:23 AM

QUOTE(Spectre @ Feb 3 2006, 03:54 PM)

As far as indentation goes, it seems to work fine for me under Opera, FireFox, and Internet Explorer.

I hope you don't mind, but I've 'cleaned up' your function slightly. Note that it is quickly written and untested, and sctructured it in the way which I normally write PHP code, which may be a bit annoying for others. Obviously, you're free to simply discard it.

CODE

<?php

function maketree( $rootcatid, $level ) {

   if( !is_numeric($rootcatid) || !is_numeric($level) ) {
      return;
   }

   $sql = 'SELECT catid, cat_name FROM tbl_name WHERE parentid = ' . $rootcatid . ' ORDER BY cat_name';

   $result = @mysql_query($sql);

   if( !$result || @mysql_num_rows($result) < 1 ) {
      return;
   }

   $level++;

   while( $sql_data = @mysql_fetch_assoc($result) ){
      $db_catid = $sql_data['catid'];
      $db_catname = $sql_data['cat_name'];
      $display = '';
      for( $i=0;$i<($level*2);$i++ ) {
         $display .= ' ';
      }
      $display .= '<option value="' . $db_catid . '">' . $db_catname . '</option>';
      echo "$display\n";
      maketree($db_catid,$level);
   }
   @mysql_free_result($result);
}

?>

You put it in a wrong order dude.
Jut change che script from :
$display .= '<option value="' . $db_catid . '">' . $db_catname . '</option>';
echo "$display\n";

to :

$diaplay = '<option value="' . $db_catid . '"> . $display' . $db_catname . '</option>';
echo "$display\n";
And that should fix your problem.

Comment/Reply (w/o sign-up)

Spectre

Feb 4 2006, 03:01 PM

Hmm, I didn't even pick up on that. Nice spotting. I just assumed the spaces where being added along with the option's text (as I noted, I didn't test anything).

Comment/Reply (w/o sign-up)