rs = new qlDatabase(); $form->dbTable = "contacts"; $form->action = "editContacts.php"; $form->method = "post"; $form->itemType = "Contact"; $form->sortBy = "nickName"; $form->categoryList = "both"; $form->idField = "id"; $form->hideID = true; $form->nowrap = "nowrap"; $form->viewField = array("nickName"=>"Nickname", "phone_num"=>"Phone #", "email1"=>"Email"); $form->catField = "category"; $form->secondaryDB = "Phone Info;id;phonenums;contact_id;id"; $form->add_element(array("type"=>"showtext", "headerRow"=>true, "name"=>"header1", "description"=>"Basic Info", "tableBreak"=>"", "maxlength"=>"100")); $form->add_element(array("type"=>"text", "name"=>"nickName", "description"=>"Nickname", "tableBreak"=>"", "maxlength"=>"30")); $form->add_element(array("type"=>"text", "name"=>"firstName", "description"=>"First Name", "tableBreak"=>"", "required"=>true, "maxlength"=>"30")); $form->add_element(array("type"=>"text", "name"=>"lastName", "description"=>"Last Name", "tableBreak"=>"", "maxlength"=>"30")); $form->add_element(array("type"=>"text", "name"=>"email1", "description"=>"email1", "tableBreak"=>"", "required"=>"", "maxlength"=>"40", "size"=>"30", "validation"=>"email")); $form->add_element(array("type"=>"text", "name"=>"email2", "description"=>"email2", "tableBreak"=>"", "maxlength"=>"40", "size"=>"30", "value"=>"", "validation"=>"email")); $form->add_element(array("type"=>"text", "name"=>"address1", "description"=>"address1", "tableBreak"=>"", "maxlength"=>"100")); $form->add_element(array("type"=>"text", "name"=>"address2", "description"=>"address2", "tableBreak"=>"", "maxlength"=>"100")); $form->add_element(array("type"=>"textarea", "name"=>"notes", "description"=>"notes")); $form->add_element(array("type"=>"select", "name"=>"phone_type", "description"=>"Phone #", "secondaryDB"=>"primary", "sharedRow"=>"first", "options"=>"ql_db;phonenums;phone_type;phone_type", "maxlength"=>"15")); $form->add_element(array("type"=>"text", "name"=>"phone_num", "description"=>"", "size"=>12, "secondaryDB"=>"secondary", "sharedRow"=>"last", "maxlength"=>"15")); $form->add_element(array("type"=>"showtext", "headerRow"=>true, "name"=>"header3", "description"=>"Category Info", "maxlength"=>"100")); $lblArray = array(array("label"=>"Calvary", "value"=>"Calvary"), array("label"=>"Family", "value"=>"Family"), array("label"=>"Financial", "value"=>"Financial"), array("label"=>"Health", "value"=>"Health"), array("label"=>"Job", "value"=>"Job"), array("label"=>"Other", "value"=>"Other"), array("label"=>"Remote", "value"=>"Remote"), array("label"=>"Sac", "value"=>"Sac"), array("label"=>"SLO", "value"=>"SLO")); $form->add_element(array("type"=>"select", "name"=>"category", "description"=>"Category", "tableBreak"=>"", "options"=>$lblArray, "selected"=>array("SLO"), "size"=>"1")); /* $lblArray = array(array("label"=>"Complete", "value"=>"complete"), array("label"=>"Stafford Bible Study", "value"=>"stafford")); $form->add_element(array("type"=>"checkbox", "name"=>"mailingLists", "description"=>"mailingLists", "tableBreak"=>"", "options"=>$lblArray, "selected"=>array("complete"), "multiple"=>true)); */ $form->add_element(array("type"=>"submit", "name"=>"submit", "value"=>"Save Contact")); $form->start(); ?>