Using multiple SELECT statements to narrow results

Using multiple SELECT statements to narrow results



I have a database with some properties that have been sold. They each have

a date associated with it which is what I need to use to narrow the search

results.

Basically I have a query:

$query = "SELECT * from newsales WHERE city = '".$_GET['location']."'";

And what I need to do is, from the results returned from the above query,

I need to further narrow it down to be within the past 90 days.

So it'll find the city, and then it needs to ONLY get the ones from the

last 90 days. How do I combine SELECT statements to narrow the results

down?

Thanks!