For Statment

[cheechm]

How do I display this in a template@

Code: Select all

     $sql = 'SELECT *
			FROM site_menu
			ORDER BY `order` ASC';
        $result = $db->sql_query($sql);

        $num = mysql_num_rows($result);
        
             for ($n = 1; $n<$num; $n++)
            {
            	$iorder = '<select name="order">';
            	$iorder .= '<option value="'. $n .'">'. $n .'</option></select>';
            	$template->assign_vars(array('SL_ORDER' => $iorder));
            	            	}

Code: Select all

<td style="text-align: center;">{SL_ORDER}</td>

I want it so output this:
Option--1
Option--2
Option--3
but it doesn't work.

Thanks

[Highway of Life]

There are two ways of doing that...

Example #1, the best method:

Code: Select all

$sql = 'SELECT *
        FROM ' . SOME_TABLE . "
        WHERE some_field = '" . $db->sql_escape($some_value) . "'";
$result = $db->sql_query($sql);

$s_option_list = '';
$i = 1;

while ($row = $db->sql_fetchrow($result))
{
    $s_option_list .= '<option value="' . $i . '">' . $row['some_field'] . '</option>';
    $i++;
}
$db->sql_freeresult($result);

$template->assign_var('S_OPTION_LIST', $s_option_list); 

Template:

Code: Select all

<select name="option_list" id="option_list">{S_OPTION_LIST}</select>

Example #2:

Code: Select all

$sql = 'SELECT *
        FROM ' . SOME_TABLE . "
        WHERE some_field = '" . $db->sql_escape($some_value) . "'";
$result = $db->sql_query($sql);

$s_option_list = '<select name="option_list" id="option_list">';
$i = 1;

while ($row = $db->sql_fetchrow($result))
{
    $s_option_list .= '<option value="' . $i . '">' . $row['some_field'] . '</option>';
    $i++;
}
$db->sql_freeresult($result);
$s_option_list .= '</select>';

$template->assign_var('S_OPTION_LIST', $s_option_list); 

Template:

Code: Select all

{S_OPTION_LIST}

Note that we correctly use $db->sql_fetchrow(), we use TABLE_CONSTANT for the table name, and we use a while loop instead of of a for loop for a database call.
In the first example, you're letting the template control the select box, as you may want different boxes containing the same data, in the second example, you would use that if you knew that no other box on a single page would contain that drop-down.
Since we are assigning only asingle var, we use assign_var() instead of assign_vars(array());

[igorw]

The first method pointed out by highway is prefered though, as it gives style authors more flexibility for styling the <select>.

[3Di]

Yes, i preferred the first though till now, maybe I have now to re-consider my though, dunno.

[Highway of Life]

I wouldn't. I would personally avoid option #2, and leave it up to the template to decide the styling of the select.