DaniWeb Forum Index > Web Development > PHP

Next button:Help

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2008

Posts: 142

Reputation: ishlux is an unknown quantity at this point

Solved Threads: 0

ishlux

Offline

Junior Poster

Next button:Help

Aug 4th, 2008

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

•

Join Date: Aug 2008

Posts: 48

Reputation: Demiloy is an unknown quantity at this point

Solved Threads: 4

Demiloy

Offline

Light Poster

Re: Next button:Help

Aug 4th, 2008

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * FROM emails LIMIT (1, 10)
SELECT * FROM emails LIMIT (1, 10)

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

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * FROM emails LIMIT (11,10)
SELECT * FROM emails LIMIT (11,10)

For the second page. Repeat, and you have it

Last edited by peter_budo; Aug 4th, 2008 at 6:48 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Jul 2008

Posts: 1,072

Reputation: Shanti Chepuru is on a distinguished road

Solved Threads: 98

Shanti Chepuru Shanti Chepuru is offline

Offline

Veteran Poster

Re: Next button:Help

Aug 4th, 2008

hello use this code:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$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'];
$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...

Last edited by Shanti Chepuru; Aug 4th, 2008 at 4:03 am.

Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..

•

Join Date: Jun 2008

Posts: 142

Reputation: ishlux is an unknown quantity at this point

Solved Threads: 0

ishlux

Offline

Junior Poster

Re: Next button:Help

Aug 4th, 2008

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.

•

Join Date: Aug 2008

Posts: 48

Reputation: Demiloy is an unknown quantity at this point

Solved Threads: 4

Demiloy

Offline

Light Poster

Re: Next button:Help

Aug 4th, 2008

•

Originally Posted by 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.

This should be the solution:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
// 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>
// 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>