mssql_query

[Anon]

Can someone direct me at what's wrong with this query? I'm new to querying. Thanks.

$results = mssql_query("select * from agent_data where ((Longitude <= '$long_sub_q') and (Longitude >= '$long_add_q')) and ((Latitude <= '$lat_sub_q') and (Latitude >= '$lat_add_q')) order by AGLONM");

[sarahk]

I would start with checking the error messages. put the sql string into a variable and echo that out.
What happens when you paste it into phpMyAdmin?
Does it look sensible?
*Do you have a case sensitivity problem?

If necessary dummy up the tables and query in M'soft Access and see what's different.