Displaying 10 Records Per Page

dvayne

Nov 25 2007, 09:46 PM

how to display 10 messages per page?

CODE

<?php
    include("config/config.inc.php");
    include("config/dbcon.php");
    include("checksession.php");

        if(isset($_POST['action'])){
        $gname = $_POST['gname'];
        $gemail = $_POST['mail'];
        $gmsg = $_POST['gmsg'];
        $date = date("m.d.y");
$sql = "insert into tblguestbook ";
$sql .= "(guestname, guestemail, guestmessage, guestdate)";
$sql .=" values('$gname','$gemail','$gmsg','$date')";
    mysql_query($sql);
    }

?>

<html>
<head><title>My Guestbook</title>
<link href="styles/style.css" rel="stylesheet" />
<script language="javascript" src="includes/validate.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css">

</style></head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="17%"> </td>
    <td width="83%" valign="bottom" > </td>
  </tr>
</table>

<form name = "form1" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>" onSubmit="return validateForm(form1)">
  <p class="fontSubTitle">Sign to Guestbook</p>
  <p class="fontSubTitle"><span class="fontText">Name: </span>
    <input type="text" name="gname">
    <br>
    <span class="fontText">Email:</span>
    <input name="mail" type="text" id="mail">
    <br>
    <span class="fontText">Message:</span>
    <textarea cols="35" rows="6" name="gmsg"></textarea>
  </p>
  <p class="fontSubTitle">
    <input type="submit" value="Send" name="action">
    <input name="reset" type="reset" value="Clear">
    <br>
  </p>
</form>
  <p>
    <?php
    $results = mysql_query("select * from tblguestbook order by guestid desc");

    while($data = mysql_fetch_object($results)){
    echo "<table width=\"500\" border=\"0\" cellpadding=\"5\" cellspacing=\"1\" class=\"borderThin\" >";
echo " <tr>\n";
echo "<td class=\"fontTextTwo\" align=\"left\" width=\"60%\">name: ";
echo "<a href=\"mailto:".$data->guestemail."\" class=\"b\">".$data->guestname."</a>";
echo "</td>\n";
            echo "<td class=\"fontTextTwo\" align=\"right\"  width=\"40%\">dated posted: ".$data->guestdate."</td>\n";
echo "  </tr>\n";
          echo "<tr>\n";
           echo " <td colspan=\"2\" class=\"fontText\" align=\"left\">".$data->guestmessage."</td>\n";
echo " </tr>\n";
echo "</table><br>";
    }

?>
</p>

</body>
</html>
<?php
    mysql_close($dbh);
?>

any help would be appreciated

Reply

jlhaslip

Nov 25 2007, 11:39 PM

Google php pagination script

here is a link to Code Walkers. They have pretty solid scripts.
http://www.codewalkers.com/c/a/Link-Farm-Code/Pagination/

Reply

galexcd

Nov 26 2007, 01:52 AM

I won't be as vague as grampa Jim was... Basically you'll want to add this bit of code to your sql query:

CODE

$results = mysql_query("select * from tblguestbook order by guestid desc LIMIT ".($rowsperpage*(is_numeric($_GET['page'])?($_GET['page']-1):0)).", ".($rowsperpage*(is_numeric($_GET['page'])?$_GET['page']:1)).";");

And then at the beginning define the variable "$rowsperpage"

CODE

$rowsperpage=5;

Reply

dvayne

Nov 27 2007, 09:35 AM

QUOTE(alex7h3pr0gr4m3r @ Nov 26 2007, 09:52 AM)

I won't be as vague as grampa Jim was... Basically you'll want to add this bit of code to your sql query:

CODE

$results = mysql_query("select * from tblguestbook order by guestid desc LIMIT ".($rowsperpage*(is_numeric($_GET['page'])?($_GET['page']-1):0)).", ".($rowsperpage*(is_numeric($_GET['page'])?$_GET['page']:1)).";");

And then at the beginning define the variable "$rowsperpage"

CODE

$rowsperpage=5;

where will I put $rowsperpage=5; ? before include("config/config.inc.php"); ?

Reply

pop

Nov 27 2007, 02:42 PM

put it before you use it.

Reply

galexcd

Nov 27 2007, 06:34 PM

Yeah anywhere before that sql query i told you to change is fine, but if I were you I'd put it at the begining of the file just incase you wanted to change how many rows per page are displayed quickly.

Reply

ADD REPLY / Got an Opinion!	a humble request :-)	RAPID SEARCH!	Free Hosting	[X]
Express your Opinions, Thoughts or Contribute your information that might help someone here. Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE