Reply to thread

Message

<blockquote data-quote="vaulient2" data-source="post: 200709" data-attributes="member: 29433">Hey guys , a few days ago I made a help thread for my pagination as it would not paginate , and I have to admit , I received great support , especially from Monsta and I thank you all. Well even if I didn't succeed even from the helps , I kept working on it and now I am in a state where it works , but only thing is that now , It shows all the contents&nbsp; and whne I click on the pagination pages ,it redirects me to the homepage of my localhost website.Here's the code[code]&lt;?PHP$p1 = 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; 0;$start = ($page - 1) * $p1;if(mysql_num_rows($getComments) == 0) {&nbsp; &nbsp; echo &quot;No comments for this article!&quot;;} else {echo '&lt;table width=&quot;528px&quot;&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($Comments = mysql_fetch_array($getComments)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getUserInfo = mysql_query(&quot;SELECT * FROM users WHERE username = '&quot;.$Comments['author'].&quot;'&quot;);$userInfo = mysql_fetch_array($getUserInfo);$nummy = mysql_query(&quot;SELECT * FROM cms_comments&quot;);$numrows = mysql_num_rows($nummy);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt; &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; &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; &lt;div style=&quot;float:left&quot;&gt;&lt;img position:absolute; src=&quot;http://habbo.fr/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&amp;size=b&amp;direction=2&amp;head_direction=3&amp;gesture=sml&amp;size=2&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; echo ' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&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; &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; &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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;80px&quot; valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &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; &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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &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;&lt;br&gt;&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; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;/table&gt;';}echo &quot;Pages: &quot;;if($p2 &gt;= 1 &amp;&amp; $page &lt;= $p2){for($x=1; $x&lt;=$p2; $x++) {echo ($x == $page) ? '&lt;strong&gt;&lt;a href=&quot;?page='.$x.'&quot;&gt;'.$x.'&lt;/a&gt;&lt;/strong&gt; ' : '&lt;a href=&quot;?page='.$x.'&quot;&gt;'.$x.'&lt;/a&gt; ';}}?&gt;[/code]&nbsp;Here's a screenie &nbsp;<a href="http://prntscr.com/122yyu" target="_blank">http://prntscr.com/122yyu</a></blockquote>

[QUOTE="vaulient2, post: 200709, member: 29433"] Hey guys , a few days ago I made a help thread for my pagination as it would not paginate , and I have to admit , I received great support , especially from Monsta and I thank you all. Well even if I didn't succeed even from the helps , I kept working on it and now I am in a state where it works , but only thing is that now , It shows all the contents and whne I click on the pagination pages ,it redirects me to the homepage of my localhost website. Here's the code [code]<?PHP $p1 = 3; $pages = mysql_query("SELECT COUNT(id) FROM cms_comments"); $p2 = ceil(mysql_result($pages, 0) / $p1); $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 0; $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); $nummy = mysql_query("SELECT * FROM cms_comments"); $numrows = mysql_num_rows($nummy); 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://habbo.fr/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&size=b&direction=2&head_direction=3&gesture=sml&size=2"></div> '; echo ' </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>'; } echo "Pages: "; if($p2 >= 1 && $page <= $p2){ for($x=1; $x<=$p2; $x++) { echo ($x == $page) ? '<a href="?page='.$x.'">'.$x.'</a> ' : '<a href="?page='.$x.'">'.$x.'</a> '; } } ?>[/code] Here's a screenie [url]http://prntscr.com/122yyu[/url] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members