Posted by Jm on 05/13/05 03:17

I'm trying to build a select/option list off of a database select.
I've confirmed that the correct data is coming out of the query. My
options are empty in the template though. This is my first attempt at
html_options. I'm doing something wrong, any help? TIA


PHP:

// Build job selector pulldown
$sql_job_pulldown = "SELECT Job FROM t_jobinfo;";

if($result = $mysqli->query($sql_job_pulldown))
{
// dump into a select statement
// fetch associative array
$smarty->assign('JOB_OPTION', $result);
$result->close();
}

TEMPLATE:

<td align='center'>Job Name</td>
<td align='center'>
<select name='job_name'>
{html_options options=$JOB_OPTION}
</select>
</td>

--
J

[Back to original message]