Next button:Help

[ishlux]

Hi all,
I have an inbox, if i click on the inbox which will display list of mails. now i have next button,
if i click on the next button it should be possible to display the next mail with respect to the current opened mail.
how to do this . Pls help me out.

Thanks in advance

[Demiloy]

SELECT * FROM emails LIMIT (1, 10)

That would be the SQL query for your first page. Then:

SELECT * FROM emails LIMIT (11,10)

For the second page. Repeat, and you have it

[Shanti C]

hello use this code:

$t="select * from `yourtable` ";
$i=mysql_query($t);
$row=mysql_fetch_array($i);
 $n="select * from yourtable where id > '".$row['id']."'";
$p=mysql_query($n);
$d=mysql_fetch_array($p);//here you will get next message...
 $nextid=$d['id'];
 $previd=$row['id'];

you just pass the $nextid and $previd to your nextpage...

[ishlux]

No its not like that, see if the current mail is 2nd and if i click on the next link it should be possible to open the 3rd mail. which ever i open , if i click on the next link. it should be possible to open the next mail corresponding to the opened current mail.

[Demiloy]

No its not like that, see if the current mail is 2nd and if i click on the next link it should be possible to open the 3rd mail. which ever i open , if i click on the next link. it should be possible to open the next mail corresponding to the opened current mail.

This should be the solution:

// File: viewmail.php?id=2

<?php
// security
if(!(is_numeric($_GET['id'])))
{
echo 'Error';
}

$id = $_GET['id'];
$query = mysql_query("SELECT * FROM emails WHERE id = $id");

while ($rows = mysql_fetch_array($query, MYSQL_ASSOC)
{
// print out whatever information (subject, author, time, text, etc.)
}
?>

<a href="viewmail.php?id=<?php echo $id--; ?>">Previous email</a>
<a href="viewmail.php?id=<?php echo $id++; ?>">Next email</a>

[its4enjoy]

Thanks

One problem i faced, so changed:

$id-- to $id - 1
$id++ to $id + 1