|
Posted by Jφrg Hermsdorf on 05/02/05 19:58
Hello List,
I would like to know if there is an easier way to
handle MySQL result sets in smarty? Currently I only
know of the approach to prepare an array out of the
resource id returned by mysql_query() :
....
$result = mysql_query('SELECT * FROM ...');
while ($row = mysql_fetch_assoc($result))
{
$result_array[] = $row;
}
$smarty->assign('results', $result_array);
Then I can use the result set within the {foreach
item=result from=$result_array}{/foreach} function.
But I'm looking for another way, where I can directly
assign the resource like this:
$smarty->assign('results', mysql_query('SELECT * FROM
....'));
.... is there a foreach-like smarty-plugin-function
that can handle a "resource id" instead of an array?
Thanks, JΓΆrg.
___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 250MB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de
[Back to original message]
|