now its working,
i was wondering if we can do max(dateposted) on update?
mysql> update datafiles set status = '1' where max(dateposted);
ERROR 1111: Invalid use of group function
hmm? seems, not to be working at all.
On Tue, 27 Jul 2004 14:43:58 +0800, Louie Miranda <[EMAIL PROTECTED]> wrote:
> ok, just removed the distinct syntax
>
>
>
> On Mon, 26 Jul 2004 23:51:43 -0500, mos <[EMAIL PROTECTED]> wrote:
> > At 10:45 PM 7/26/2004, you wrote:
> > >if I understand you correctly, this should do it.
> > >
> > >select distinct office, max(dateposted)
> > >from table
> > >group by office
> >
> >
> > Just one more thing. You don't need "distinct" because you are already
> > using "group by".
> >
> > Mike
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
>
> --
> Louie Miranda
> http://www.axishift.com
>
--
Louie Miranda
http://www.axishift.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
