Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include ('adm/connectdb.php');
- $num = 8;
- if (isset($_POST['search'])) {
- $page = $_GET['page'];
- $result = mysql_query("SELECT COUNT(*) FROM `db1` WHERE `name`LIKE "%$search%"");
- $posts = mysql_result($result, 0);
- $total = intval(($posts - 1) / $num) + 1;
- $page = intval($page);
- if(empty($page) or $page < 0) $page = 1;
- if($page > $total) $page = $total;
- $start = $page * $num - $num;
- $result = mysql_query("SELECT * FROM `db1` WHERE `name`LIKE "%$search%" LIMIT $start, $num");
- while ( $postrow[] = mysql_fetch_array($result))
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement