#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Surabaya, Indonesia
    Posts
    3
    Rep Power
    0
    I need for help. I really compused, and my problem is how to php limiting result and begin-next links. I write my scripts in this page..so maybe you, all members can help my problem.
    <?php

    require("esensi.php3");

    mysql_connect($hostname,$username,$password);

    $tablename = "OPINI";

    $tmt = "select * from $tablename order by OpTanggal Desc LIMIT 2,20";

    $result = mysql_db_query($databasename,$tmt);

    while($rowdat = mysql_fetch_object($result)) {

    $dsum = $rowdat->OpSumber;
    $djab = $rowdat->OpJabatan;
    $dtgl = $rowdat->OpTanggal;
    $djud = $rowdat->OpJudul;
    $daba = $rowdat->OpAbstrak;
    $dlen = $rowdat->OpLengkap;
    $dpen = $rowdat->OpPengirim;

    ?>
    <tr>
    <td width="720" valign="top">
    <p align="left"><font face="Arial Narrow" size="2" style="margin-top: -1; margin-bottom: -5" noshade>
    <?php
    echo "<b><i>".$dtop."</i><b>";
    ?>
    </font></p>
    </td>
    </tr>
    <tr>
    <td width="720" valign="top">
    <p align="left"><font face="Arial Narrow" size="2" style="margin-top: -3; margin-bottom: -5" noshade>
    <?php
    $tahun = substr($dtgl,0,4);
    $bulan = substr($dtgl,5,2);
    $tgl = substr($dtgl,8,2);
    echo $tgl."-".$bulan."-".$tahun."&nbsp&nbsp&nbsp";
    // echo $dtgl."&nbsp&nbsp";

    echo Reporter.":".$dpen;
    ?>

    </font></p></td>
    </tr>
    <tr>
    <td width="720" valign="top">
    <p><font face="Arial Narrow" size="1" style="margin-top: 1; margin-bottom: 7; margin-left: 5"><i>
    <a href="http://www.esensi.com/Informasi/OpiniDetail1.php3?
    kjud=<?php echo nl2br(stripslashes($djud));?>
    $ksum=<?php echo nl2br(stripslashes($dsum));?>
    &kaba=<?php echo nl2br(stripslashes($daba));?>
    &klen=<?php echo nl2br(stripslashes($dlen));?>
    &kpen=<?php echo nl2br(stripslashes($dpen));?>
    "><?php echo nl2br(stripslashes($djud)); ?></a></i>
    </font></p>
    </td>
    </tr>
    <tr>
    <td width="720" valign="top">
    <p align="justify"><font face="Arial Narrow" size="2" style="margin-top: -3; margin-bottom: -5" noshade>
    <?php
    echo $daba;
    ?>
    </font></p>
    </td>
    </tr>
    <tr>
    <td width="720" valign="top">
    <p align="left"><font face="Arial Narrow" size="2" style="margin-top: -3; margin-bottom: -3" noshade>
    <hr>
    </td>
    </tr>

    <?php } ?>

    thanks a lot to all that can help.

    ------------------
    adipoer@esensi.com
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    visit the following link: http://www.phpbuilder.com/columns/rod20000221.php3

    ------------------
    SR -
    webshiju.com
    www.jobxyz.com-IT Career Portal
    ezipindia.com--WebStudio


    "The fear of the LORD is the beginning of knowledge..."

Similar Threads

  1. Check MySQL Version thru PHP
    By wolftrap1 in forum PHP Development
    Replies: 2
    Last Post: February 11th, 2004, 09:51 PM
  2. Replies: 5
    Last Post: February 11th, 2004, 03:18 AM
  3. Replies: 0
    Last Post: February 11th, 2004, 12:44 AM
  4. Getting data from different tables in Mysql with PHP
    By Bosw8er in forum PHP Development
    Replies: 3
    Last Post: February 10th, 2004, 05:25 PM
  5. fread problem: doesn t compile php code
    By ghorghor2002 in forum PHP Development
    Replies: 2
    Last Post: February 3rd, 2004, 06:25 AM

IMN logo majestic logo threadwatch logo seochat tools logo