function getNice()
{
if ($this->config['source']['type'] == 'table' && isset($this->config['source']['name'])) {
global $thinkedit;
$config = new config();
//$table = $thinkedit->newTable($this->config['source']['name']);
//
//$source->filter('id', '=', $this->getRaw());
$source_table = $this->config['source']['name'];
$title_fields = $config->getTitleFields($source_table);
require_once 'query.class.php';
$query = new query();
$query->addTable($this->config['source']['name']);
$query->addWhere('id', '=', $this->getRaw());
$results = $query->select();
if (count($results) > 0) {
foreach ($config->getTitleFields($source_table) as $field) {
$out .= $results[0][$field] . ' ';
}
return $out;
} else {
return $this->getRaw();
}
} else {
return $this->getRaw();
}
}
<?php
require_once '../thinkedit.init.php';
require_once '../class/query.class.php';
$query = new query();
$query->addTable('roles');
$query->addWhere('id', '=', 5);
echo $query->getSelectQuery();
echo '<hr>';
$query->addValue("id", "5 and the like's");
$query->addValue("role", "john");
echo $query->getInsertQuery();
