MachForm Community Forums Topic: Can I add a "LIMIT" statement?

MachForm Community Forums Topic: Can I add a "LIMIT" statement? https://www.machform.com/forums/ MachForm Community Forums Topic: Can I add a "LIMIT" statement? en Sun, 03 May 2026 23:07:10 +0000 redityo on "Can I add a "LIMIT" statement?" https://www.machform.com/forums/topic/can-i-add-a-limit-statement#post-4118 Thu, 01 Jan 2009 09:34:43 +0000 redityo 4118@https://www.machform.com/forums/ Hi Ron, I think you wrong put the limit statement, it should be like this <pre><code>select A.*, B.option as month, C.option as year from (ap_form_4 as A left join ap_element_options as B on A.element_1=B.option_id and B.element_id=1 and B.form_id=4) left join ap_element_options as C on A.element_2=C.option_id and C.element_id=2 and C.form_id=4 LIMIT 1,10</code></pre> rscott7706 on "Can I add a "LIMIT" statement?" https://www.machform.com/forums/topic/can-i-add-a-limit-statement#post-4114 Wed, 31 Dec 2008 22:56:22 +0000 rscott7706 4114@https://www.machform.com/forums/ Yes, it crashed it. I may be trying to put it in the wrong place. Here is the error code: 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 ' B.option as month, C.option as year from (ap_form_4 as ' at line 2 I put the limit statement here: $query = "select A.* LIMIT 1, 10, B.option as month, C.option as year from Thanks!! Ron yuniar on "Can I add a "LIMIT" statement?" https://www.machform.com/forums/topic/can-i-add-a-limit-statement#post-4111 Wed, 31 Dec 2008 17:56:47 +0000 yuniar 4111@https://www.machform.com/forums/ I suppose so. Did you get any error message when you add the LIMIT? rscott7706 on "Can I add a "LIMIT" statement?" https://www.machform.com/forums/topic/can-i-add-a-limit-statement#post-4109 Wed, 31 Dec 2008 11:57:45 +0000 rscott7706 4109@https://www.machform.com/forums/ Following is code that works great for some online newsletters. But, I get one continuous column (year 2006 through 2008) - not useful as is. I would like to break in to year columns. Can I add a LIMIT statement to the following code (i.e LIMIT 1, 12): $query = "select A.*, B.option as month, C.option as year from (ap_form_4 as A left join ap_element_options as B on A.element_1=B.option_id and B.element_id=1 and B.form_id=4) left join ap_element_options as C on A.element_2=C.option_id and C.element_id=2 and C.form_id=4"; $result = mysql_query($query) or die(mysql_error()); echo ""; while($row = mysql_fetch_array($result)){ echo ""; echo ""; echo $row['month']; echo " "; echo $row['year']; echo " "; echo "<a href='$row[element_4]'>  -  View</a>"; echo ""; echo ""; echo " "; } ?>