Smarty

[rreen]

Hi There

I'm new to smarty and i've got a problem:

I have a oracle table with values, i extract the data from this table through oci8
after i want to sho the data in a select field.

code in the template:

<form action="{$aktie}" method="post" enctype="multipart/form-data" name="picup"
target="_self" id="picup">
<b>Producer/Studio:<br>
<select name=prod_id>
{html_options options=$producers selected=$prod_id1}
</select>

Code in the php-script:

while (OCIFetch($stmt))
{
$prid[]= OCIResult($stmt, "PROD_ID");
$prnaam[]= $row[OCIResult($stmt, "PROD_NAAM")];
}
OCILogoff($con);


$smarty->assign('producers', array(
$prid => $prnaam
));
$smarty->assign('prod_id1', $prid[0]);


But i can't see nothing, tried several things....
what is wrong here?


greetings

Richard

[boots]

$smarty->display('template.tpl');

I think the way you assign the producers array is incorrect. It has to be a normal associative array of name, value pairs. You seem to be setting a single key (which is actually an array) and a single value (also an array).

[rreen]

I've figured out that i was using the wrong oci-statement, it had to be ocifetchinto...this gave me as result a array. also had to change the template and the result is how i would expect it.

Greetings
Richard