Page 1 of 1
need some mysql help
Posted: Sat 20 Jun 2015 12:18 pm
by n9mfk
Hi,
I need some mysql help
I like to update daily all the by month tags to a database i am not sure how to do it
thanks for any help
beau
Re: need some mysql help
Posted: Sat 20 Jun 2015 1:35 pm
by mcrossley
I have to ask why? That data can all be derived from the day data can it not? That's the beauty of having the data in a database, you can extract whatever you want.
Re: need some mysql help
Posted: Sat 20 Jun 2015 8:53 pm
by n9mfk
Hi Mark,
I like to do a page like
http://n9mfk.info/cumulusmx/records.php using mysql
but have no idea how?
beau
Re: need some mysql help
Posted: Sat 20 Jun 2015 11:40 pm
by tobyspond
Beau,
This should get you started:
SELECT maxtemp, monthname(logdate), day(logdate), year(logdate) from dayfile order by maxtemp desc limit 1
You will need a query for each variable. Mark may have a more elegant method.
Kerry