MySql Help

[karma]

hello there

im currently building up a little shoutbox but have come across a lickle problem

at the moment i have this

<?php

ob_start(); 

$host = "localhost"; 
$username = "*****"; 
$password = "*****"; 
$databasename = "*****"; 

$ip = $_SERVER['REMOTE_ADDR'] . NULL; 
$ip = str_replace(".", "-", $ip); 

$c = mysql_connect($host, $username, $password) or die("Cannnot connect"); 
mysql_select_db($databasename, $c); 

$query = "SELECT * FROM shoutbox ORDER BY id DESC LIMIT 5"; 
$result = mysql_query($query);

while( $r = mysql_fetch_array($result) ) { 
    $name = $r['name']; 
    $mail = $r['email']; 
    $message = $r['message']; 
    $date = $r['date']; 

	echo "<div class=\"coltop\">By: <a href=\"mailto:$mail\">$name</a> on: $date</div><div class=\"message\">$message</div><table width=\"150\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"onepx\" align=\"center\">
<tr>
      <td></td>
    </tr>
  </table>
"; 
} 

function submit() { 
    echo "<div align=\"center\"><form class=\"forminput\" name=\"shoutbox\" method=\"post\" action=\"shoutbox.php\">t;input class=\"forminputmain\" name=\"name\" type=\"text\" id=\"name\" value=\"Name\"> 
<input class=\"forminputmain\" name=\"email\" type=\"text\" id=\"email\" value=\"E-Mail\"> 
<textarea class=\"forminputmain\" name=\"message\" id=\"message\">Message</textarea> 
     <br> 
      <input class=\"forminputmain\" type=\"submit\" name=\"Submit\" value=\"Submit\"></form></div>"; 


    if (isset($_POST['name'])) { 
        mysql_query("INSERT INTO `shoutbox` (`name` , `email` , `message` , `date` , `remote_addr` ) VALUES ( '" . $_POST['name'] . "', '" . $_POST['email'] . "', '" . $_POST['message'] . "', '" . date("d/m/y") . "', '" . $ip . "');"); 
         
        $insertGoTo = "shoutbox.php";
  print "<script language=\"JavaScript\">";
print "window.location = '$insertGoTo' ";
print "</script>";
         
    } 
} 

submit(); 

?>

Now this works fine and everything is ok BUT i would like to add the option of next page previous page which i am having troubles doing.

I want it to show 5 results as it is doing fine but then as i say the option to go next and previous

Any help using the above code would be great!

Thanks in advance

[metal_dragen Veteran]

Great tut at PHPFreaks.

[karma]

Didnt work for me using code i already have.

I need to know how to get it with what i have now and i did ask Here not at PHP freaks.

Thanks for replying though i appreciate it

[Gekko G.]

limit lets you set starting record, then how many records from that point on

<?

//z is the starting point, initilize to 0

$z = 0;

//add 5 to this starting point everytime user hit "next page"

if ($_REQUEST['z'])

$z = $_REQUEST['z'] + 5;

$query = "SELECT * FROM shoutbox ORDER BY id DESC LIMIT $z, 5";

?>

this is the link

<a href = <?=$PHP_SELF?>?z=<?=$z?>>Next Page</a>

[karma]

thanks access but where would i add that?

sorry im a bit of a novice trying to break into this side of things

[TurboTuna]

anywhere should do it, but best to add it at the bottom me thinks