Jump to content

Archived

This topic is now archived and is closed to further replies.

redarrow

prev next 123... help cheers

Recommended Posts



Can some one help me i need to add a prev and next with numbers but i tried but failed cheers.

If the user has more then 1 message the user can press prev next and number.

[code]
$query="select * from member_messages where id='$id'";
$result=mysql_query($query);
while($record=mysql_fetch_assoc($result)){
echo"<table width='200'border='4' bordercolor='black'><td align='center'><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><table>";
echo "<table width='200'border='4' bordercolor='black'><td align='center'><b>Read Message:

<font color='red'>Read</b></font></td></table><br><br>";

}
[/code]

Share this post


Link to post
Share on other sites
[code]

<?
if(!isset($_GET['page'])){
    $page = 1;
} else {
    $page = $_GET['page'];
}


$max_results = 10;


$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 width='200'border='4' bordercolor='black'><td align='center'><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><table>";
echo "<table width='200'border='4' bordercolor='black'><td align='center'><b>Read Message:

<font color='red'>Read</b></font></td></table><br><br>";

}



$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM

member_messages"),0);


echo "<center>Select a Page<br />";


if($page > 1){
    $prev = ($page - 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</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\">Next>></a>";
}
echo "</center>";

?>
[/code]

Share this post


Link to post
Share on other sites
Well what exactley isn't working with it at the moment?

"If the user has more then 1 message the user can press prev next and number."

In this one it's over 10 though

Share this post


Link to post
Share on other sites
This is the code so far as the above was wrong know the message is showwing the two messages when the second should be on the page number 2 but issint lol cheers


[code]

if(!isset($_GET['page'])){
    $page = 1;
} else {
    $page = $_GET['page'];
}

$max_results = 10;


$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 width='200'border='4' bordercolor='black'><td align='center'><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><table>";
echo "<table width='200'border='4' bordercolor='black'><td align='center'><b>Read Message:

<font color='red'>Read</b></font></td></table><br><br>";

}



$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM

member_messages"),0);


$total_pages = ceil($total_results / $max_results);


echo "<center>Select a Page<br />";


if($page > 1){
    $prev = ($page - 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</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\">Next>></a>";
}
echo "</center>";

?>
[/code]

Share this post


Link to post
Share on other sites
[!--sizeo:5--][span style=\"font-size:18pt;line-height:100%\"][!--/sizeo--]solved[!--sizec--][/span][!--/sizec--]

[code]
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 width='200'border='4' bordercolor='black'><td align='center'><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><table>";
echo "<table width='200'border='4' bordercolor='black'><td align='center'><b>Read Message:

<font color='red'>Read</b></font></td></table><br>";

}



$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\">Previous>></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\">Next>></a>";
}
echo "</center>";

?>
[/code]

Share this post


Link to post
Share on other sites
i got a slight problam

as you can see from the above code i am using it for users to look at who sent a message.

but when i want to go to to a read page to read that message i get all the messages in the database
with a while loop.

example

if i press 1 i get the two messages in the database i did try limit 1 but if you then goto page 2 you only get message 1 on the read page.

From the code above how do you get a link to corerspond to the data in the database so if link 2 had message from god then you see message from god on the read page.

i tried page=$page&id='$id' // dont work

also the otherway around.

so the quiestion is how do you get the data in a database to be seen from a pagatinton to another page.

or otherwise i have to show all messages and theat defeats the code get me

heres the read.php page example
[code]

$db=mysql_connect("localhost","root","admin");
mysql_select_db("promotor",$db);



$query="select * from member_messages where id='$id'";
$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<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>Send A Reply    <font color='red'><a

href='send_message.php?&id=$id'>reply</a></b></font></td></table><br>";

}
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.