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

• Next in forum: AW: [SMARTY] direct way to handle mysql result sets (via resource id) with smarty
• Prev in forum: Re: dir's
• Thread view: direct way to handle mysql result sets (via resource id) with smarty

[Reply to this message]