Confuse with Smarty Template

[sanu]

Smarty I found it hard to understan
this is my php file

$result=$db->Execute("Select * from  cat");
 while(!$result->EOF){
   print($result->Fields['name']);

  $result1=$db->Execute("Select * from subcat where  cat_id='".$result->Fields['id']."' ");
     while(!$result1->EOF){
       print($result1->Fields['name']);
      $result1->MoveNext();
      }
$result->MoveNext();
}

how to display query resultset in Smarty like
Vehicle
-Bike
-Cars
Computer
-Laptop
-Pc

[mrgym]

you must ;

//initialize the smarty class
$mysmarty = NEW smarty;

//get your bike variable
$bike = ???;

//assign this variable to your class;
$mysmarty->assign("bike", $bike);

//display the template with the bike variable;
$mysmarty->display("mytemplate.html");

[sanu]

i mean i am using php lib template it has block function from whch we can control nested loop but how to do i t wi th smarty
please help me