php - MYSQL INNER JOIN syntax error -
i have been trying fix issue on since morning :)
i have 2 tables. table1= post table2=users. need extract data both tables. searched how use inner join, found codes. run query inside phpmyadmin , works fine here sql query
select post.topic_id, post.category_id, post.topic_id, post.post_creator, post.post_date, post.post_content, users.username, users.gender, users.id post inner join users on post.post_creator=users.id post.post_creator=users.id , post.topic_id=19 order post.post_date desc
but when use sql query inside php gives me error
you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'inner join users on post.post_creator=users.id order post.post_date asc' @ line 1
below php code
<?php include_once './forum_scripts/connect_to_mysql.php'; $cid = $_get['cid']; if(isset($_session['uid'])){ $logged = " | <a href ='create_topic.php?cid=".$cid."'>click here create new topic</a> "; }else{ $logged = " | please log in create topics in forum."; } $tid = $_get['tid']; $sql = "select * topics category_id='".$cid."' , id='".$tid."' limit 1"; $res = mysql_query($sql) or die(mysql_error()); if(mysql_num_rows($res) == 1){ echo "<table width='100%'> "; if(isset($_session['uid'])){ echo "<tr><td colspan='2'><input type='submit' value='add reply' onclick=\"window.location = 'post_reply.php?cid=".$cid."&tid=".$tid."'\" /> | <a href = 'http://amaforum.net63.net/'>return forum index</a><hr />"; }else{ echo "<tr><td colspan='2'><p>please log in add reply</p><hr /></td>";} while ($row = mysql_fetch_assoc($res)){ $sql2 = "select post.topic_id, post.category_id, post.topic_id, post.post_creator, post.post_date, post.post_content, users.username, users.gender, users.id" . "from post inner join users on post.post_creator=users.id order post.post_date asc" ; $res2 = mysql_query($sql2) or die(mysql_error()); while ($row2 = mysql_fetch_assoc($res2)) { echo "<tr><td valign='top' style='border:2px solid #000000'><div style='min-height: 125px;'>".$row['topic_title']."<br /> ".$row2['post_creator']." - ".$row2['post_date']."<hr />".$row2['post_content']."</div></td>" . "<td width='200' valign='top' style='border: 1px solid #000000;'>" . "<input id='".d_text."' type='".text."' name='".the_creator."' value='".$row2['post_creator']."' >" . "echo '$user_info' " . "</td></tr>" . "<tr><td colspan='2'><hr /></td></tr> "; } $old_views = $row['topic_views']; $new_views = $old_views + 1; $sql3 = "update topics set topic_views='".$new_views."' category_id='".$cid."' , id='".$tid."' limit 1 "; $res3 = mysql_query($sql3) or die (mysql_error()); } echo "</table>"; }else{ echo "<p>this topic not exist</p>"; } mysql_close(); ?> i can work , need guys..
thanks in advance
this should solve problem (i've added space missing when concatenated 2 lines of sql query):
<?php include_once './forum_scripts/connect_to_mysql.php'; $cid = $_get['cid']; if(isset($_session['uid'])){ $logged = " | <a href ='create_topic.php?cid=".$cid."'>click here create new topic</a> "; }else{ $logged = " | please log in create topics in forum."; } $tid = $_get['tid']; $sql = "select * topics category_id='".$cid."' , id='".$tid."' limit 1"; $res = mysql_query($sql) or die(mysql_error()); if(mysql_num_rows($res) == 1){ echo "<table width='100%'> "; if(isset($_session['uid'])){ echo "<tr><td colspan='2'><input type='submit' value='add reply' onclick=\"window.location = 'post_reply.php?cid=".$cid."&tid=".$tid."'\" /> | <a href = 'http://amaforum.net63.net/'>return forum index</a><hr />"; }else{ echo "<tr><td colspan='2'><p>please log in add reply</p><hr /></td>";} while ($row = mysql_fetch_assoc($res)){ $sql2 = "select post.topic_id, post.category_id, post.topic_id, post.post_creator, post.post_date, post.post_content, users.username, users.gender, users.id " . "from post inner join users on post.post_creator=users.id order post.post_date asc" ; $res2 = mysql_query($sql2) or die(mysql_error()); while ($row2 = mysql_fetch_assoc($res2)) { echo "<tr><td valign='top' style='border:2px solid #000000'><div style='min-height: 125px;'>".$row['topic_title']."<br /> ".$row2['post_creator']." - ".$row2['post_date']."<hr />".$row2['post_content']."</div></td>" . "<td width='200' valign='top' style='border: 1px solid #000000;'>" . "<input id='".d_text."' type='".text."' name='".the_creator."' value='".$row2['post_creator']."' >" . "echo '$user_info' " . "</td></tr>" . "<tr><td colspan='2'><hr /></td></tr> "; } $old_views = $row['topic_views']; $new_views = $old_views + 1; $sql3 = "update topics set topic_views='".$new_views."' category_id='".$cid."' , id='".$tid."' limit 1 "; $res3 = mysql_query($sql3) or die (mysql_error()); } echo "</table>"; }else{ echo "<p>this topic not exist</p>"; } mysql_close(); ?> to avoid issues in future, it's practice log sql that's being executed in code somewhere, or echo onto web page while testing. way you'll debug issues this.
Comments
Post a Comment