createSelectQuery(); $stmt = $sq->select( 'name', 'country', 'lat', 'lon' ) ->from( 'city' ) ->where( $sq->expr->like( 'name', $sq->bindValue( 'frankfurt%' ) ) ) ->orderBy( 'country', 'name' ) ->prepare(); $stmt->execute(); foreach ( $stmt as $entry ) { list( $name, $country, $lat, $lon ) = $entry; printf( '%s, %s is @ %.2f%s %.2f%s
', $name, $country, abs( $lat ), ($lat > 0 ? "N" :"S" ), abs( $lon ), ( $lon > 0 ? "E" : "W" ) ); } ?>