Anyone good with SMARTY?

[m_tt]

Can someone PLEASE tell me how mysql should be setup for nested sections. This is exactly what I need but I cannot get the arrays setup right. From the smarty documentation:

{section name=customer loop=$custid}
	id: {$custid[customer]}<br>
	name: {$name[customer]}<br>
	address: {$address[customer]}<br>
	{section name=contact loop=$contact_type[customer]}
		{$contact_type[customer][contact]}: {$contact_info[customer][contact]}<br>
	{/section}
	<p>
{/section}

PLEASE HELP AND SORRY IF IT'S BEEN POSTED. I've tried EVERYTHING 🙁

Sorry for posting this in multiple forums, I need a quick answer 🙁

[mrgym]

Can you show your php?
Have you tried to display your variables to make sure they are correct before you display them in the template?

Using smarty is usually a matter of

1. declaring the smarty class

   • $mytemp = NEW Smarty;

2. assigning values to the php variables

   • $custid[ ] array
   • $name[ ] array
   • $address[ ] array

3. making the template

   • this was your example

4. displaying the smarty template

   • $mytemp->display("templatename");

[Orjan]

Well, as you're talking mysql I guess this would be the best way.. as I do atleast..

$sql= "SELECT...."
$custresult = mysql_query($sql) or die();
$i=0;
while ($custrow = mysql_fetch_array($custresult)) {
    $customer_id = $custrow[cust_id];
    $custinfo[$i][cust_id] = $customer_id;
    $custinfo[$i][cust_name] = foo;

$sql= "SELECT.... WHERE customer = '$customer_id'"
$contresult = mysql_query($sql) or die();
$ii = 0;
$continfo = array();   // reset the variable
while ($controw = mysql_fetch_array($contresult)) {
    $cont_id = $controw[cont_id];
    $continfo[$ii][cont_id] = $cont_id;
    $continfo[$ii][cont_name] = foofoo;
    $ii++;
}
 $custinfo[$i][contacts] = $continfo;
 $i++;
}
$smarty->assign("customers", $custinfo);

[trooper]

Matt please do NOT post the same question in multiple boards

I have answered your post in another board - it makes it very difficult to see how the thread is progressing

here's my tuppence worth

[jayant]

closed coz of double posts

see http://www.phpbuilder.com/board/showthread.php?threadid=10243380