query($q);
echo "| Field | Type | Null |
";
while($set->next()){
$field=$set->getString('Field');
$fields[]=$field;
$type=$set->getString('Type');
$null=$set->getString('Null');
echo "| ".$field." | ";
echo "".$type." | ";
echo "".$null." |
";
}
echo "
";
}
function selectni($tablename,$where){
global $database;
$q="describe $tablename";
$set=$database->query($q);
if ($where=="") {
$q2="select * from $tablename";
}else{
$q2="select * from $tablename where $where";
}
echo $q2."
";
$set2=$database->query($q2);
while($set->next()){
$field=$set->getString('Field');
$fields[]=$field;
$type=$set->getString('Type');
$null=$set->getString('Null');
}
for($i=0;$i".$fields[$i]."";
}
echo "
";
while($set2->next()){
for($i=0;$igetString($fields[$i]);
echo "|:|".$onefield;
}
echo "
";
}
}
?>