Help with a query

Sql

[belfasttim]

Sorry to post a dumb question, I think this is simple but I've been banging my head against it and could use another set of eyes-- any help appreciated!

I'm data mining for searches run from my website. Many searches run each day, so I need to get the average for each value for each day in the date range. How would I do this with a single query? Right now I'm messing with:

SELECT AVG(price_low), AVG(price_high), AVG(parts_low), AVG(parts_high), DATE(timestamp) AS date
FROM searches WHERE 1
GROUP BY timestamp

So instead of having 200 rows returned for only 10 dates, I'd like 10 rows, with averages of the values searched within each day.

[belfasttim]

Nevermind, just forgot the distinct at the beginning of the statement. otherwise works as is.

thanks anyway

[whoisgregg]

Glad you got it sorted belfasttim. :)

[LifeinAsia]

Glad you got it sorted

Actually, I think he got it GROUPed... ;)

[whoisgregg]

::groan:: Good one, LifeinAsia. ;)