Good Query, Bad Query

Anon

Does this look like a valid query to y'all?

$results = mssql_query("select *, sqrt [(sqr('$longitude' + Longitude)) + (sqr("$latitude" + Latitude))] as miles from agent_data where Longitude >= '".$long_sub_q."' and Longitude <= '".$long_add_q."' and Latitude >= '".$lat_sub_q."' and Latitude <= '".$lat_add_q."' and AGLZIP = '$zip' order by miles");

Thanks.

Mark

Anon

Here's where I'm at:

$results = mssql_query("select *, sqrt (sqr('$longitude' + Longitude) + sqr('$latitude' + Latitude)) as miles, from agent_data where Longitude >= '".$long_sub_q."' and Longitude <= '".$long_add_q."' and Latitude >= '".$lat_sub_q."' and Latitude <= '".$lat_add_q."' and AGLZIP = '$zip' order by miles");

I get back...

Warning: MS SQL message: 'sqr' is not a recognized function name. (severity 15) in c:\inetpub\wwwroot\find_an_agent\results.nycm on line 136

What's wrong with my 'sqr' function?
Thanks.

fitzbean

SQR is not a mySQL function. SQRT is, but not SQR.

[deleted]

MS-sql, not mySQL. :-)

The explenation stands though, if the database tells you sqr is not recognised then 'obviously' there must be a different name for it. Check the manual (or search the wonderfully transparent MS website).

A forum, a FAQ, what else do you need?