untuk mendapatkan jumlah data dari tabel
jangan menggunakan select * tapi select count(*)
setelah itu baru select * from tabel order by no desc
LIMIT $offset, $bt_pph";
kalao data ada 1 jt bagaimana tuh kena select * :(
--- ANDRI ARISANDY <[EMAIL PROTECTED]> wrote:
> Assalammualaikum Wr Wb.
>
> Sebelumya koneksi ke mysql dulu
> mysql_connect("localhost","","");
> mysql_select_db("pegawai");
>
> Kalau kamu menggunakan database mysql
> kemuadian beribatasan setiap halaman berapa record
> $bt_pph = 100;
>
> kemudian baca jumlah datanya dulu
> $query = "SELECT * FROM downloadpc";
> $hasil = mysql_query($query);
> $jmlhalaman = ceil(mysql_num_rows($hasil) /
> $bt_pph);
>
> if(!isset($page))
> {
> $page = 0;
> }
> $offset = $page * $bt_pph;
>
> $perintah="SELECT DISTINCT kategori FROM
> downloadpc
> order by no desc LIMIT $offset, $bt_pph";
>
> mysql_connect("localhost","","");
> mysql_select_db("pegawai");
>
> $tampil_data=mysql_query($perintah);
>
> $nomer=1;
> echo("<font face='verdana' size='2'
> color='#336699'><b><center>Download
> Category</center></b></font><hr size='1'
> color='#336699'><br>");
> while($data=mysql_fetch_array($tampil_data))
> {
> echo("<table align='left' border='0'
> cellspacing='0'
> cellpadding='0'><tr><td><font face='verdana' size=1
> color='#336699'>$nomer.</font> <a
> class='anavymerah' target='_self'
>
href='lihatdownload.php?kategori=$data[kategori]'>$data[kategori]</a></td></tr></table><br>");
> $nomer++;
> }
> echo("<br><font face='verdana' size='1'
> color='#336699'>Page:</font>");
>
> //---Halaman
> for($i=0;$i<$jmlhalaman;$i++)
> {
> echo("<font face='verdana' size='1'
> color='#336699'>[</font><a class='anavymerah'
> href='tampilkatgdownload.php?page=$i'
> target='_self'>$i</a><font face='verdana' size='1'
> color='#336699'>]</font>");
> }
>
>
> Tetapi Ini hanya menampilkan berdasarkan halaman
> tidak ada next dan prev, tetapi berdasarkan halaman
> page[0 1 2 3 4 dst]
> ya mungkin prinzipnya hampir sama...
>
> Semoga bermanfaat...
> Wassalam
>
> G_thuk
>
> --- catur <[EMAIL PROTECTED]> wrote:
>
> > Salam hormat & sejahtera selalu...
> >
> >
> > Bagaimana caranya menampilkan hal dlm web agar
> data
> > tampil 100
> > rec/halaman web, trus ada button Next - Prev. Saya
> > sudah cuba dng limit
> > tapi blon berhasil u/hal ke 2.
> > Saya menggunakan script antara lain ...
> >
> > if action == lanjut
> > {
> > ini scriptnya
> > }
> >
> > if action == lalu
> > {
> > ini scriptnya
> > }
> >
> > form action="xxx.php" method="post">
> > <input type="Hidden" name="action" value="lanjut">
> > <input type="Hidden" name="action" value="lalu">
> > <input type="submit" name="submit" value="Next">
> > <input type="submit" name="submit" value="Prev">
> > </form>
> >
> > --
> >
> >
> > --
> > Berhenti langganan:
> > [EMAIL PROTECTED]
> > Arsip dan info: http://linux.or.id/milis.php
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
> --
> Berhenti langganan:
> [EMAIL PROTECTED]
> Arsip dan info: http://linux.or.id/milis.php
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
--
Berhenti langganan: [EMAIL PROTECTED]
Arsip dan info: http://linux.or.id/milis.php
