<div>
<div class="content wysiwyg-content">
hi, i want to pull 1 column of data from mysql and put it into 
smarty template that use 
 
listmenu or html_option 
 
&nbsp;i have something like this 
 
==================================================================================== 
$query = &quot;SELECT * FROM package&quot;; 
$query_result = @mysql_query ($query) OR error(mysql_error()); 
while ($info = @mysql_fetch_array($query_result)) 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$types_temp = array(); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$types_temp = $info['pack_name']; 
 
} 
 
STemplate::assign('types_temp', $types_temp); 
================================================================================= 
 
TPL: 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;select name=&quot;package&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;option value='null'&gt;-- none --&lt;/option&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {html_options options=$packnamez.sohai } 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/select&gt; 
 
 
does my TPL correct? i cant figure it work :( 
some 1 please help
</div>
</div>

hi, i want to pull 1 column of data from mysql and put it into
smarty template that use

listmenu or html_option

 i have something like this

====================================================================================
$query = "SELECT * FROM package";
$query_result = @mysql_query ($query) OR error(mysql_error());
while ($info = @mysql_fetch_array($query_result))
{
	$types_temp = array();
	
	$types_temp = $info['pack_name'];

}

STemplate::assign('types_temp', $types_temp);
=================================================================================

TPL:
 <select name="package">
 <option value='null'>-- none --</option>
 {html_options options=$packnamez.sohai }
 </select>


does my TPL correct? i cant figure it work :(
some 1 please help

PHP : how to assign variable from mysql to smarty

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.