https://www.machform.com/forums/ MachForm Community Forums Topic: Join Tables Question en Sun, 03 May 2026 23:07:40 +0000 https://www.machform.com/forums/topic/join-tables-question#post-7525 Thu, 01 Oct 2009 12:46:50 +0000 yuniar 7525@https://www.machform.com/forums/ <p>I think you forgot to close the double quote for your query, it should be like this:</p> <pre><code>$query = &quot;SELECT id, date_created FROM ap_form_1, ap_element_options WHERE ap_form_1.id = ap_element_options.form_id ORDER BY date_created DESC&quot;;</code></pre> https://www.machform.com/forums/topic/join-tables-question#post-7509 Thu, 01 Oct 2009 01:15:10 +0000 rscott7706 7509@https://www.machform.com/forums/ <p>For some reason, the following query works fine (QUERY 1), but the one further down (QUERY 2) that attempts to join tables does not.</p> <p>I know questions here should be about Machform, but it would solve a lot of problems for me if I can get the "join tables" concept down pat.</p> <p>I left out username and password from code.</p> <p>Here is a link to the one that works:</p> <p><a href="https://communityrecoveryteam.org/volunteer%20form/apForm1_List.php" rel="nofollow">https://communityrecoveryteam.org/volunteer%20form/apForm1_List.php</a></p> <p>QUERY 1</p> <p>&lt;?php<br /> echo "&lt;font face=\"verdana\"&gt;";<br /> echo "<br />";<br /> $db = mysql_connect("localhost", "", "");<br /> mysql_select_db("crtsdorg_userforms");</p> <p>$query = "SELECT * FROM ap_form_1 ORDER BY id desc";</p> <p>$result = mysql_query($query) or die(mysql_error());<br /> echo "&lt;font face=\"arial\"&gt;";<br /> while($row = mysql_fetch_array($result)){<br /> echo "<br />ID: ";<br /> echo $row['id'];<br /> echo "&nbsp;&nbsp;Date Volunteered: ";<br /> echo $row['date_created'];<br /> }<br /> ?&gt;</p> <p>QUERY 2</p> <p>&lt;?php<br /> echo "&lt;font face=\"verdana\"&gt;";<br /> echo "<br />";<br /> $db = mysql_connect("localhost", "", "");<br /> mysql_select_db("crtsdorg_userforms");</p> <p>$query = "SELECT id, date_created<br /> FROM ap_form_1, ap_element_options<br /> WHERE ap_form_1.id = ap_element_options.form_id<br /> ORDER BY date_created DESC;</p> <p>$result = mysql_query($query) or die(mysql_error());<br /> echo "&lt;font face=\"arial\"&gt;";<br /> while($row = mysql_fetch_array($result)){<br /> echo "<br />ID: ";<br /> echo $row['id'];<br /> echo "&nbsp;&nbsp;Date Volunteered: ";<br /> echo $row['date_created'];<br /> }<br /> ?&gt;</p> <p>Here is the error:<br /> Parse error: syntax error, unexpected T_STRING in /home6/crtsdorg/public_html/volunteer form/apForm1_List2.php on line 13 </p>