SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:51 AM
| ||||
| ||||
 Re: Query Problems 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 <mdykman@gmail.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 <douglassa@gmail.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 > - mdykman@gmail.com > > - All models are wrong. Some models are useful. >      |
 |
« Re: confirm unsubscribe to mysql@lists.mysql.com
|
Question related to MySQL and Threads and "Context_voluntary" »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:51 AM.
