Reply to thread

Message

<blockquote data-quote="Markshall" data-source="post: 199974" data-attributes="member: 1872">No comments were showing because you ran an if statement saying&nbsp;[php]if ($numrows != 0)[/php]&nbsp;$numrows hadn't even been declared so it wouldn't have shown anything.&nbsp;As far as I know, this should work.&nbsp;[PHP]&lt;?php$getComments = mysql_query(&quot;SELECT * FROM cms_comments WHERE article = '&quot;.filter($_GET['id']).&quot;' ORDER by id DESC&quot;);?&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;div class=&quot;cbb clearfix notitle &quot;&gt;&lt;div id=&quot;article-wrapper&quot;&gt;&lt;h2&gt;Comments &lt;?php echo mysql_num_rows($getComments); ?&gt;&lt;/h2&gt;&lt;div class=&quot;article-meta&quot;&gt;&lt;/div&gt;&lt;div class=&quot;article-body&quot;&gt;&lt;?PHP$p1 = 3; // thanks PHPAcademy for Pagination tuts &lt;3$pages = mysql_query(&quot;SELECT COUNT(id) FROM cms_comments&quot;);$p2 = ceil(mysql_result($pages, 0) / $p1);$page = (isset($_GET['page'])) ? (int)$_GET['page'] :&nbsp; 1;$start = ($page - 1) * $p1;if(mysql_num_rows($getComments) == 0) {&nbsp; &nbsp; echo &quot;No comments for this article!&quot;;} else {&nbsp; &nbsp; echo '&lt;table width=&quot;528px&quot;&gt;';&nbsp; &nbsp; &nbsp; &nbsp; while($Comments = mysql_fetch_array($getComments)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getUserInfo = mysql_query(&quot;SELECT * FROM users WHERE username = '&quot;.$Comments['author'].&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $userInfo = mysql_fetch_array($getUserInfo);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;90px&quot; valign=&quot;top&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;height: 65px;width: 50px;float: left;overflow: hidden;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;float:left&quot;&gt;&lt;img position:absolute; src=&quot;http://www.habbo.fr/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&amp;size=s&amp;direction=2&amp;head_direction=3&amp;gesture=sml&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;427px&quot; valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;i&gt;&lt;a href=&quot;/me&quot;&gt;'.$userInfo['username'].' &lt;/a&gt;&lt;/i&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&lt;br /&gt;'.$Comments['comment'].'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;80px&quot; valign=&quot;top&quot;&gt;&lt;/td&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;400px&quot; align=&quot;right&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;width:125%; height:1px; background-color:#ccc; margin-top:-17px;&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;/table&gt;';}?&gt;[/PHP]</blockquote>

[QUOTE="Markshall, post: 199974, member: 1872"] No comments were showing because you ran an if statement saying [php]if ($numrows != 0)[/php] $numrows hadn't even been declared so it wouldn't have shown anything. As far as I know, this should work. [PHP]<?php $getComments = mysql_query("SELECT * FROM cms_comments WHERE article = '".filter($_GET['id'])."' ORDER by id DESC"); ?> <div class="habblet-container "> <div class="cbb clearfix notitle "> <div id="article-wrapper"><h2>Comments <?php echo mysql_num_rows($getComments); ?></h2> <div class="article-meta"></div> <div class="article-body"> <?PHP $p1 = 3; // thanks PHPAcademy for Pagination tuts <3 $pages = mysql_query("SELECT COUNT(id) FROM cms_comments"); $p2 = ceil(mysql_result($pages, 0) / $p1); $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1; $start = ($page - 1) * $p1; if(mysql_num_rows($getComments) == 0) { echo "No comments for this article!"; } else { echo '<table width="528px">'; while($Comments = mysql_fetch_array($getComments)){ $getUserInfo = mysql_query("SELECT * FROM users WHERE username = '".$Comments['author']."'"); $userInfo = mysql_fetch_array($getUserInfo); echo '<tr> <td width="90px" valign="top"></div> <div style="height: 65px;width: 50px;float: left;overflow: hidden;"> <div style="float:left"><img position:absolute; src="http://www.habbo.fr/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&size=s&direction=2&head_direction=3&gesture=sml"></div> </td> <td width="427px" valign="top"> <a href="/me">'.$userInfo['username'].' </a> '.$Comments['comment'].' </td> </tr> <tr> <td width="80px" valign="top"></td> <td width="400px" align="right"> </div></div></div></div> <div style="width:125%; height:1px; background-color:#ccc; margin-top:-17px;"></div> </td> </tr>'; } echo '</table>'; } ?>[/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members