Posts

Showing posts from 2016

Finding nearby longitude and latitude within specific distance in database

 To get near by cities which are having longitude and latitude within specific distance in database

SELECT * FROM
(
SELECT * FROM
(
SELECT *,(((acos(sin((@latitude*pi()/180)) * sin((Latitude*pi()/180))+cos((@latitude*pi()/180))
 * cos((Latitude*pi()/180)) * cos(((@longitude - Longitude)*pi()/180))))*180/pi())*60*1.1515*1.609344) as distance
 FROM tblCities
) t
)x where distance <= 1000
ORDER by distance

List of special Characters in HTML

List of special Characters in HTML

left single quote&lsquo;right single quote&rsquo;single low-9 quote&sbquo;left double quote&ldquo;right double quote&rdquo;double low-9 quote&bdquo;dagger&dagger;double dagger&Dagger;per mill sign&permil;single left-pointing angle quote&lsaquo;single right-pointing angle quote&rsaquo;black spade suit&spades;black club suit&clubs;black heart suit&hearts;black diamond suit&diams;overline, = spacing overscore&oline;leftward arrow&larr;upward arrow&uarr;rightward arrow&rarr;downward arrow