hi hi query($segment_query) or die($mysqli->error.__LINE__); if($segment_result->num_rows > 0) { while($s = $segment_result->fetch_array()){ $segment = array(); $segment['id'] = $s['segment_id']; $segment['color'] = $s['color']; $coordinates = array(); $offset = 9; $pts = unpack("@$offset/d*", $s[2]); $geom = array(); $pair = false; $count = 0; $i = 1; while($i < count($pts)){ $geom[0] = $pts[$i]; $i = $i + 1; $geom[1] = $pts[$i]; $i = $i + 1; $coordinates[$count] = $geom; $count = $count + 1; } $segment['coordinates'] = $coordinates; $segments[$segment["id"]] = $segment; } } ?>