<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><DIV></DIV>
<DIV> $query = "SELECT nc.nid, n.title, nc.daycount AS views, nc.totalcount, "<BR> . "(SELECT COUNT(*) FROM {comments} c WHERE c.timestamp >= %d AND c.nid=nc.nid) AS comments_today, "<BR> . "cs.comment_count "<BR> . "FROM {node_counter} nc "<BR> . "INNER JOIN {node} n ON n.nid=nc.nid "<BR> . "LEFT JOIN {node_comment_statistics} cs ON cs.nid=nc.nid "<BR> . "WHERE nc.daycount > 0 "<BR> . "ORDER BY nc.daycount DESC";<BR> $result = pager_query($query, $page_limit, 0, NULL, $today);</DIV>
<DIV> </DIV>
<DIV><FONT color=#7f003f>This comes out looking like:</FONT></DIV>
<DIV>SELECT nc.nid, n.title, nc.daycount AS views, nc.totalcount, (SELECT COUNT(*) FROM {comments} c WHERE c.timestamp >= %d AND c.nid=nc.nid) AS comments_today, cs.comment_count FROM {node_counter} nc INNER JOIN {node} n ON n.nid=nc.nid LEFT JOIN {node_comment_statistics} cs ON cs.nid=nc.nid WHERE nc.daycount > 0 ORDER BY nc.daycount DESC</DIV>
<DIV> </DIV>
<DIV>user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS comments_today, cs.comment_count FROM node_counter nc INNER JOIN node n ON ' at line 1 query: SELECT COUNT(*) FROM comments c WHERE c.timestamp >= 1270699200 AND c.nid=nc.nid) AS comments_today, cs.comment_count FROM node_counter nc INNER JOIN node n ON n.nid=nc.nid LEFT JOIN node_comment_statistics cs ON cs.nid=nc.nid WHERE nc.daycount > 0 in C:\www\webapps\drupal6\sites\all\modules\mymodule\mymodule.pages.inc on line 672.<BR><BR> </DIV>
<P><FONT face="bookman old style, new york, times, serif" color=#ff007f size=4><EM><STRONG>Nancy E. Wichmann, PMP</STRONG></EM></FONT></P>
<DIV><BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: Courier New, courier, monaco, monospace, sans-serif"><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><FONT face=Tahoma size=2>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Aaron Winborn <winborn@advomatic.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> development@drupal.org<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thu, April 8, 2010 1:20:38 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [development] Strange query problem<BR></FONT><BR>Can you post your Drupal query? Hard to troubleshoot w/o the original code.<BR><BR>nan wich wrote:
<BLOCKQUOTE type="cite">
<DIV style="FONT-SIZE: 12pt; COLOR: rgb(192,0,0); FONT-FAMILY: Courier New, courier, monaco, monospace, sans-serif">
<DIV>I have the following query, which works fine in PhpMyAdmin, but Drupal upchucks on it. Why?</DIV>
<DIV> </DIV>
<DIV><FONT color=#000000>SELECT nc.nid, n.title, n.created, nc.daycount AS views_today, nc.totalcount AS total_views, <BR> (SELECT COUNT(*) FROM comments c WHERE c.timestamp >= 1270699200 AND c.nid=nc.nid) AS comments_today, <BR> cs.comment_count <BR> FROM node_counter nc <BR> INNER JOIN node n ON n.nid=nc.nid <BR> LEFT JOIN node_comment_statistics cs ON cs.nid=nc.nid <BR> WHERE nc.daycount > 0 <BR> ORDER BY nc.daycount DESC</FONT></DIV>
<DIV> </DIV>
<DIV>Yes, in Drupal, I do put the brackets around the table names.</DIV>
<DIV> </DIV>
<DIV>The error message says there's a problem at " AS comments_today, cs.comment_count FROM...".<BR> </DIV>
<P><FONT face="bookman old style, new york, times, serif" color=#ff007f size=4><EM><STRONG>Nancy E. Wichmann, PMP</STRONG></EM></FONT></P>
<P><FONT face="arial, helvetica, sans-serif"><SPAN style="FONT-SIZE: 11pt; COLOR: rgb(99,36,35); FONT-FAMILY: 'sans-serif'">Sometimes the questions are complicated and the answers are simple. - Dr. Suess</SPAN></FONT></P></DIV></BLOCKQUOTE><BR><BR><PRE class=moz-signature>--
Aaron Winborn
Advomatic, LLC
http://advomatic.com/
Drupal Multimedia available in September!
http://www.packtpub.com/create-multimedia-website-with-drupal/book
My blog:
http://aaronwinborn.com/</PRE></DIV></DIV></div></body></html>