OOH Form with template

[hello world]

I am having problem with the OOH form with template.  Now I can load latest value from those field and do a iupdate statement due to update statement also get the same value from the select statement.

Please help!

<?
require_once("./config/config.php");
$perm->check("user");

$tpl = new Template;
$tpl->set_file("contact_form", "contact_form.html");

$tpl->set_block("contact_form", "contact_form_block", "tpl_contact_form");
$tpl->set_var(array("pagetitle" => "Contact",
                    "title" => "<b>Contact</b>"));   

$contactid = CCGetParam("contactid");

if ($contactid)
{
    $sql = new DB_eontap;
    $sql->query("SELECT * from contact where contactid = $contactid");
    $numrows = $sql->num_rows($sql);
    while ($sql->next_record())
        {
            $name = $sql->f("name");
            $company = $sql->f("company");
            $jobtitle = $sql->f("jobtitle");
            $ic = $sql->f("ic");
            $workphone = $sql->f("workphone");
            $workext = $sql->f("workext");
            $mobilephone = $sql->f("mobilephone");
            $faxnumber = $sql->f("faxnumber");
            $pagernumber = $sql->f("pagernumber");
            $emailaddress= $sql->f("emailaddress");
        }
}

$f = new form;

$HTMLFormName = "contact_form";
$Action = "contact_form.php";

$f->add_element(array("type"=>'hidden',
                      "name"=>'contactid',
                      "value"=>"$contactid"));

$f->add_element(array("type"=>'text',
                      "name"=>'name',
                      "size"=>'60',
                      "value"=>"$name"));

$f->add_element(array("type"=>'text',
                      "name"=>'company',
                      "size"=>'40',
                      "value"=>"$company"));

$f->add_element(array("type"=>'text',
                      "name"=>'jobtitle',
                      "size"=>'40',
                      "value"=>"$jobtitle"));

$f->add_element(array("type"=>'text',
                      "name"=>'ic',
                      "size"=>'15',
                      "value"=>"$ic"));

$f->add_element(array("type"=>'text',
                      "name"=>'workphone',
                      "size"=>'15',
                      "value"=>"$workphone"));

$f->add_element(array("type"=>'text',
                      "name"=>'workext',
                      "size"=>'5',
                      "value"=>"$workext"));

$fldmobilephone=$f->add_element(array("type"=>'text',
                      "name"=>'mobilephone',
                      "size"=>'15',
                      "value"=>"$mobilephone"));

$f->add_element(array("type"=>'text',
                      "name"=>'faxnumber',
                      "size"=>'15',
                      "value"=>"$faxnumber"));

$f->add_element(array("type"=>'text',
                      "name"=>'pagernumber',
                      "size"=>'15',
                      "value"=>"$pagernumber"));

$f->add_element(array("type"=>'text',
                      "name"=>'emailaddress',
                      "size"=>'50',
                      "value"=>"$emailaddress"));

if ($submit)
{
        if ($err = $f->validate())
        {
            echo $err;
            $f->load_defaults();
        }
        else
        {
            $tpl->get_vars(array("$mobilephone" => "mobilephone"));
            $sql = new DB_eontap;
            $sql->query("UPDATE contact set name='$name', company='$company', jobtitle='$title', ic='$ic', workphone='$workphone', workext='$workext', mobilephone='$fldmobilephone', faxnumber='$faxnumber', pagernumber='$pagernumber', emailaddress='$email' WHERE contactid='$contactid'");
        }
}

$f->get_start();

$tpl->set_var(array("contactid" => $f->get_element('contactid'),
            "name" => $f->get_element('name'),
            "company" => $f->get_element('company'),
            "jobtitle" => $f->get_element('jobtitle'),
            "ic" => $f->get_element('ic'),
            "workphone" => $f->get_element('workphone'),
            "workext" => $f->get_element('workext'),
            "mobilephone" => $f->get_element('mobilephone'),
            "faxnumber" => $f->get_element('faxnumber'),
            "pagernumber" => $f->get_element('pagernumber'),
            "emailaddress" => $f->get_element('emailaddress'),
            "HTMLFormName" => $HTMLFormName,
            "Action" => $Action));

$f->get_finish();
$tpl->parse("tpl_contact_form", "contact_form_block", true);
$tpl->pparse("OUTPUT", "contact_form");
page_close();
?>

[hello world]

seem like no activity in phplib forum.  okay never mind I give up already.

Now trying adodb with smarty