how to paginate this??

[techiefreak05]

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]

[redarrow]

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]

[techiefreak05]

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"

[redarrow]

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]

[techiefreak05]

tried it ... :-P i saw u were missing the ' after 'yes

[redarrow]

from
[code]
while ($array = mysql_fetch_assoc($query)){
[/code]
to
[code]
while ($array = mysql_fetch_array($query)){

[/code]

[techiefreak05]

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 ...

[redarrow]

try this for one min
[code]
$query="SELECT * FROM friends WHERE `username` = '$user' LIMIT $from, $max_results";
[/code]

[techiefreak05]

i got the same error.. again. hmm what could be wrong?

[redarrow]

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]

[techiefreak05]

"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

[redarrow]

$query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes' LIMIT $from, $max_results";

$result=mysql_query($query);

while($array=mysql_fetch_assoc($result)){

[redarrow]

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>



<?php



if(!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]

[techiefreak05]

well those 3 fixes you posted worked!!

[redarrow]

good happy now

[Jenk]

redarrow - it's [code=php:0]$_SESSION['username'][/code] not [code=php:0]$_SESSION[username][/code]

[redarrow]

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.

[Jenk]

don't tak offence... I merely corrected a mistake..

[techiefreak05]

i think .. i made him mad.. idk how.. :-(

[Jenk]

still experiencing problems?

echo all your queries to see if they are 'correct'

[redarrow]

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

[techiefreak05]

no, my code works PERFECT. absolutely perfect, thank you! i just thought redarrow was mad

[redarrow]

iam iam lol good luck mate