$c = new Uscode(); $c->select('city'); $c->like('city', $code, 'after'); $c->distinct(); $c->order_by('city', 'asc'); $c->get(10);
SELECT DISTINCT `city` FROM (`uscode`) WHERE `city` LIKE 'h%' ORDER BY `city` asc LIMIT 10
foreach($c->all as $city){ echo $city->city."<br />"; }