<?php
if (isset($_GET['st'])) {
$st = $_GET['st'];
} else {
$st = 0;
}
include "dbgrid.php";
$a = new dbGrid('localhost', 'test', 'root', 'password');
// Set Display Colors and table properties -----------------------
$a->setProperties("#000000", "10", "2", "800");
// Display Column Names ------------------------------------------
$a->setShowHeader(1);
// This is How you set custom column header ----------------------
//$a->setCustomHeader("Column1|Column2|Column3");
// Display Data Grid ---------------------------------------------
$a->displayGrid("test1", $st);
break;
}
window.open(url,'','location=0');
}
</script>
</head>
<body bgcolor="<?php
echo $_SESSION["bgcolor"];
?>
" onload="winInit();">
<?php
$sql = $db->getJoinRecord("clientes(+)ruas|cli_ruaid=rua_id\n\t\t (+)bairros|bai_id=cli_baiid", $wh, 'cli_nome', 0);
//echo $sql;
$grid = new dbGrid();
$grid->sql = $sql;
$grid->header = array("Nome", "Endereço", "Fone");
$grid->fields = array("cli_nome", "rua_nome", "cli_foneprinc");
$grid->pfields = array("Nome", "Endereço", "Fone");
$grid->js = "manda";
$grid->js_campos = "0#1";
//$grid->limite = 15;
$grid->size = 400;
$grid->event = "OnDblclick";
$grid->exec = 0;
$grid->altercolor = true;
$grid->show();
$form->Append("<hr>");
$form->append("<li><a href='#' onclick='showRelat(1);return false;' class='modulo'><b>Clientes Duplos</b></a></li>");
$window = new window(10, 30, '400px', '550px', 'consulta', 'consulta', '', '');
