Query failed-too long
<p><div class="snippet" data-lang="js" data-hide="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>$query = mysql_query("SELECT * FROM chapter LEFT JOIN page ON chapter.chapterID=page.chapterID WHERE page.category AND chapter.category LIKE 'Novice' GROUP BY page.pageID,page.chapterID  ")or die('Query failed');</code></pre>
</div>
</div>
</p>

<p>I have the following query but i also want to add the following <code>WHERE chapter.lectureID=1</code> how can i do so. i tried this :</p>

<p><div class="snippet" data-lang="js" data-hide="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>$query = mysql_query("SELECT * FROM chapter LEFT JOIN page ON chapter.chapterID=page.chapterID WHERE chapter.lectureID=1,page.category AND chapter.category LIKE 'Novice' GROUP BY page.pageID,page.chapterID  ")or die('Query failed');</code></pre>
</div>
</div>
</p>

<p>But query failed.</p>