From: Douglas Araujo (douglassagmail.com)
Date: Thu Jul 19 2007 - 11:25:10 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

We solved it here,

There was a problem in the query, we removed the "t1" at the 'group by'
section. The problem was really a sintax error in the code not in the
server.

Thanks,

Douglas

2007/7/19, Michael Dykman <mdykmangmail.com>:
>
> instead of leaving it in PHP, please print out your fully formatted
> query so we can see excatly what PHP is sending to MySQL:
>
> instead of :
>
> $qr = mysql_query("Select Distinct t1.RemaEstacao as et, t1.RemaData
> as dt, max(t1.Remahora) as mx from cadRema as t1, cadEstacoes as t2
> where t1.RemaData = '".$qdata."' and t1.RemaEstacao = t2.EstCodigo
> group by t1.et order by mx DESC ,t1.RemaEstacao ");
>
>
> try :
>
> $myquery = "Select Distinct t1.RemaEstacao as et, t1.RemaData as dt,
> max(t1.Remahora) as mx from cadRema as t1, cadEstacoes as t2 where
> t1.RemaData = '".$qdata."' and t1.RemaEstacao = t2.EstCodigo group by
> t1.et order by mx DESC ,t1.RemaEstacao ";
> echo $myquery;
> mysql_query($myquery);
>
> by the symptoms you describe along with the little investigation we
> did yesterday, it appears your problem is somewhere in that string.
>
> - michael
>
>
>
> On 7/18/07, Douglas Araujo <douglassagmail.com> wrote:
> > Hello everydoby,
> >
> > I'm having a problem executing a query in the MySQL server version 4.1,
> the
> > same query works fine in my other server with MySQL version 4.0.
> >
> > My PHP code is attached, and the query is one on the line 13.
> >
> > Please somebody help me,
> >
> >
> > Thanks,
> >
> > Douglas
> >
> >
>
>
> --
> - michael dykman
> - mdykmangmail.com
>
> - All models are wrong. Some models are useful.
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]