Hi, thx for viewing this.
problem:
i want to display my data in database like this one:
i used this script now:
the code that i used show up like this:Code:<?php include("admin/connect.php"); $dataPerPage = 2; if(isset($_GET['page'])) { $noPage = $_GET['page']; } else $noPage = 1; $offset = ($noPage - 1) * $dataPerPage; $sql = "SELECT * FROM product_book LIMIT $offset, $dataPerPage"; $result = mysql_query($sql) or die('Error'); $rs = mysql_query($sql); while( $fetch= mysql_fetch_array($rs)){ ?> <tr> <td width="400px;"> <?php $pecah = explode("more", $fetch['content']); $excerpt = $pecah[0]; ?> <div class="fontContent news" align="justify"> <?=$excerpt?><br /> <a href="pBooks.php?id=<?=$fetch[0]?>">read more . . .</a> </div> <br /><br /> </td> </tr> <?php } $query = "SELECT COUNT(*) AS jumData FROM product_book"; $hasil = mysql_query($query); $data = mysql_fetch_array($hasil); $jumData = $data['jumData']; $jumPage = ceil($jumData/$dataPerPage); ?> <div class="num"> <?php if ($noPage > 1) echo "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage-1)."'><< Prev</a>"; for($page = 1; $page <= $jumPage; $page++) { if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage)) { if (($showPage == 1) && ($page != 2)) echo "..."; if (($showPage != ($jumPage - 1)) && ($page == $jumPage)) echo "..."; if ($page == $noPage) echo " <b>".$page."</b> "; else echo " <a href='".$_SERVER['PHP_SELF']."?page=".$page."'>".$page."</a> "; $showPage = $page; } } if ($noPage < $jumPage) echo "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage+1)."'>Next >></a>"; ?>
it's show only in a single coloum.
So how to make it happen?
thx in advanced....
this is a direct link to my project:
http://imaxxo.net/rotkan/listBooks.php



Reply With Quote
Bookmarks