/**
* generate a table-select statement
* @param string $from
* @param array|string $what
* @return Query
*/
public function select($from, $what = Query::WILDCARD)
{
$query = Query::getInstance();
if (!empty($from)) {
$query->queryString = 'SELECT ';
if (!is_array($what) && is_string($what)) {
$query->queryString .= Query::WILDCARD !== $what ? '`' . $what . '`' : $what;
$query->queryString .= ' FROM `' . $from . '`';
} else {
if (empty($what)) {
return $this->select($from);
}
foreach ($what as $num => $col) {
$query->queryString .= '`' . $col;
$query->queryString .= $num + 1 < count($what) ? '`, ' : '`';
}
$query->queryString .= ' FROM `' . $from . '`';
}
}
return $query;
}
