kgundula

// Calculating the bounding box 
function boundbox ($lat, $lon, $distance, $units="km") {

	return array ( "N" => getDestinationCoordinates ($lat,$lon,   0,$distance,$units),
					"E" => getDestinationCoordinates ($lat,$lon,  90,$distance,$units),
					"S" => getDestinationCoordinates ($lat,$lon, 180,$distance,$units),
					"W" => getDestinationCoordinates ($lat,$lon, 270,$distance,$units));


}

kgundula

SELECT * FROM 
(
    SELECT TOP 30 *, ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS rnum 
    FROM table1
) a
WHERE rnum > 10 

kgundula

/*
* This function can be use to build a menu tree.
*/
function buildMenuTree($menus, $parentId = 0) {
	$branch = array();
	foreach ($menus as $menu) {
		if ($menu['parent_id'] == $parentId) {
      $children = $this->buildMenuTree($menus, $menu['id']);
      if ($children) {
        $menu['child'] = $children;