On 2/11/07, Pete <[EMAIL PROTECTED]> wrote: > >$query ="SELECT timetext, Time, groupa, country, value FROM_UNIXTIME(Time) > > FROM membercount t1 WHERE Time = (SELECT MAX(Time) FROM membercount t2 WHERE > > Comma after value?
Thanks, its "going" - However that only gives me 2 values - the latest entries - not daily for each group... I think my small script is getting there - except it doesn't give the latest... I might just do a foreach loop on the whole database & extract the latest figures.... (Ive done it, but a MYSQL query will be faster (processing) - in the long run - especially when the database grows...) -- G NZ community groups - [EMAIL PROTECTED] Freecycle Auckland :- http://groups.yahoo.com/group/AucklandFreecycle/
