techiefreak05 Posted September 8, 2006 Share Posted September 8, 2006 i have this little script to view all user friends.. and i want to limit it to about 5 per-page so my page doesnt scroll down a long way.. how would i add pagination??[code]<?php$user = $_SESSION[username];$query = mysql_query("SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes'");while ($array = mysql_fetch_array($query)){$to=$array['friend'];echo "<br><center><b>" .$to. "</b></center>";echo "<a href='sendMessage.php?to=" .$to. "'>-Message " .$to. "-</a> |<a href='getInfo.php?user=" .$to."'> -Get Info-</a> | <a href='http://zycoworld.com/" .$to. "'>-View zPage-</a><br><form action=\"\" method=\"post\"> <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\"><tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"delete\" value=\"-Remove-\"></td></tr><input type=\"hidden\" name=\"friend\" value=\"$to\"></table></form>";}?>[/code] Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 just set this $max_results = 1;example only not tested ok.good luck.[code]<?php session_start();$user = $_SESSION[username];if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } $max_results = 1; $from = (($page * $max_results) - $max_results); $query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes LIMIT $from, $max_results";while ($array = mysql_fetch_assoc($query)){$to=$array['friend'];echo "<br><center><b>" .$to. "</b></center>";echo "<a href='sendMessage.php?to=" .$to. "'>-Message " .$to. "-</a> |<a href='getInfo.php?user=" .$to."'> -Get Info-</a> | <a href='http://zycoworld.com/" .$to. "'>-View zPage-</a><br><form action=\"\" method=\"post\"> <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\"><tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"delete\" value=\"-Remove-\"></td></tr><input type=\"hidden\" name=\"friend\" value=\"$to\"></table></form>";$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM friends where `username` = '$user'"),0); $total_pages = ceil($total_results / $max_results); if($page > 1){ $prev = ($page - 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"></a>"; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; } } if($page < $total_pages){ $next = ($page + 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\"></a>";} }?>[/code] Quote Link to comment Share on other sites More sharing options...
techiefreak05 Posted September 8, 2006 Author Share Posted September 8, 2006 i got this : "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/zycoworld.flamelicker.com/newlayout/index.php on line 104" Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 this[code]$query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes LIMIT $from, $max_results";[/code]to this[code]$query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes' LIMIT $from, $max_results";[/code] Quote Link to comment Share on other sites More sharing options...
techiefreak05 Posted September 8, 2006 Author Share Posted September 8, 2006 tried it ... :-P i saw u were missing the ' after 'yes Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 from[code]while ($array = mysql_fetch_assoc($query)){[/code]to[code]while ($array = mysql_fetch_array($query)){[/code] Quote Link to comment Share on other sites More sharing options...
techiefreak05 Posted September 8, 2006 Author Share Posted September 8, 2006 i got the same error again.. heres line 93 - 117[code]if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } $max_results = 1; $from = (($page * $max_results) - $max_results); (LINE 104) $query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes LIMIT $from, $max_results";while ($array = mysql_fetch_array($query)){$to=$array['friend'];echo "<br><center><b>" .$to. "</b></center>";echo "<a href='sendMessage.php?to=" .$to. "'>-Message " .$to. "-</a> |<a href='getInfo.php?user=" .$to."'> -Get Info-</a> | <a href='http://zycoworld.com/" .$to. "'>-View zPage-</a><br><form action=\"\" method=\"post\"> <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\"><tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"delete\" value=\"-Remove-\"></td></tr><input type=\"hidden\" name=\"friend\" value=\"$to\"></table></form>";[/code]line 104 is the line mysql said was giving me probs ... Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 try this for one min[code]$query="SELECT * FROM friends WHERE `username` = '$user' LIMIT $from, $max_results";[/code] Quote Link to comment Share on other sites More sharing options...
techiefreak05 Posted September 8, 2006 Author Share Posted September 8, 2006 i got the same error.. again. hmm what could be wrong? Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 trie this ok.[code]<?php session_start();$user = $_SESSION[username];if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } $max_results = 1; $from = (($page * $max_results) - $max_results); $query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes' LIMIT $from, $max_results";$result=mysql_query($query);while($array=mysql_fetch_assoc($result)){$to=$array['friend'];echo "<br><center><b>" .$to. "</b></center>";echo "<a href='sendMessage.php?to=" .$to. "'>-Message " .$to. "-</a> |<a href='getInfo.php?user=" .$to."'> -Get Info-</a> | <a href='http://zycoworld.com/" .$to. "'>-View zPage-</a><br><form action=\"\" method=\"post\"> <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\"><tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"delete\" value=\"-Remove-\"></td></tr><input type=\"hidden\" name=\"friend\" value=\"$to\"></table></form>";$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM friends where `username` = '$user'and `accepted` = 'yes'"),0); $total_pages = ceil($total_results / $max_results); if($page > 1){ $prev = ($page - 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"></a>"; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; } } if($page < $total_pages){ $next = ($page + 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\"></a>";} }?>[/code] Quote Link to comment Share on other sites More sharing options...
techiefreak05 Posted September 8, 2006 Author Share Posted September 8, 2006 "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/zycoworld.flamelicker.com/newlayout/index.php on line 104"same error.. on the same line... again Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 $query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes' LIMIT $from, $max_results";$result=mysql_query($query);while($array=mysql_fetch_assoc($result)){ Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 heres one i just made and works fine.[code]<?php session_start();$db=mysql_connect("localhost" , "xxx" , "xxxx");mysql_select_db("promotor",$db);?><html><head><title>Send Message</title><body bgcolor="#A0C0F0"><br><br><br><br><br><?phpif(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } $max_results = 1; $from = (($page * $max_results) - $max_results); $query="select * from member_messages where id='$id' LIMIT $from, $max_results";$result=mysql_query($query);while($record=mysql_fetch_assoc($result)){echo"<table align='center' width='300'border='4' bordercolor='black'><td align='left'><b>Members Id:<font color='red'><br>".$record["sent_id"]."</font><br> User Name: <font color='red'><br>".$record["members_name"]."</font><br>Sent Time: <font color='red'><br>".$record["time"]."</font> <br> Sent Date <font color='red'><br>".$record["date"]."</font> </b></td><td align='center' valign='top'><b>Members Message <font color='red'>$page</font><b><br><br><b><div align='left'><textarea col='7' rows='7'style='color: white; background-color: #A0C0F0'>".$record["message"]."</textarea></td></b></div><table>";echo "<table align='center' width='300'border='4' bordercolor='black'><td align='center'><b>";$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM member_messages where id='$id'"),0); $total_pages = ceil($total_results / $max_results); echo "<center><b>Select A Message!</b><br>"; if($page > 1){ $prev = ($page - 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"></a>"; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; } } if($page < $total_pages){ $next = ($page + 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\"></a>";} echo "</center>"; echo'</td></table>';echo "<table align='center' width='300'border='4' bordercolor='black'><td align='center'><b>Send A Reply <font color='red'><a href='reply_message.php?&id=".$record['sent_id']."'>Reply</a></b></font><font color='red'><a href='delete_message.php?&cmd=delete&time=".$record['time']."&id=".$record['sent_id']."'>Delete</a></b></font></td></table><br>";}?>[/code] Quote Link to comment Share on other sites More sharing options...
techiefreak05 Posted September 8, 2006 Author Share Posted September 8, 2006 well those 3 fixes you posted worked!! Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 good happy now Quote Link to comment Share on other sites More sharing options...
Jenk Posted September 8, 2006 Share Posted September 8, 2006 redarrow - it's [code=php:0]$_SESSION['username'][/code] not [code=php:0]$_SESSION[username][/code] Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 i didnt write that code so tell the designer ok sorry i only inplemented the rest.if you look at the first post your notice that and i totaly agree, i can not sit here doing all the work for the user can i.dont no why your pointing this out as all i do is help others but thank you i pm the user and tell them ok. Quote Link to comment Share on other sites More sharing options...
Jenk Posted September 8, 2006 Share Posted September 8, 2006 don't tak offence... I merely corrected a mistake.. Quote Link to comment Share on other sites More sharing options...
techiefreak05 Posted September 8, 2006 Author Share Posted September 8, 2006 i think .. i made him mad.. idk how.. :-( Quote Link to comment Share on other sites More sharing options...
Jenk Posted September 8, 2006 Share Posted September 8, 2006 still experiencing problems?echo all your queries to see if they are 'correct' Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 have you still got problams you told me that it all ok now my friend not iam not mad i love helping all.i like jenk but he likes a good row i can tell lol Quote Link to comment Share on other sites More sharing options...
techiefreak05 Posted September 8, 2006 Author Share Posted September 8, 2006 no, my code works PERFECT. absolutely perfect, thank you! i just thought redarrow was mad Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 8, 2006 Share Posted September 8, 2006 iam iam lol good luck mate Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.