Jump to content

pagination


hakmir

Recommended Posts

Hi Guys,

I tried to put pagination code into my search results but every time I get an ugly error. Can you guys help me please?I just want to put 5 results per page. Why does it have to be so complicated. I am just asking something very simple (Well, it shows that you don't know anything about php dude! ( I am just talking to myself))

 

<a href="search.php">Search</a><br>
<br>
<?php     

    include("connect.php");  

    $first_name = "%" . $_POST["first_name"] . "%";
    $last_name = "%" . $_POST["last_name"] . "%";
    $age = "%" . $_POST["age"] . "%"; 

    $query=  "SELECT * FROM `contacts` WHERE `first_name` LIKE '$first_name' AND `last_name` LIKE '$last_name' AND `age` LIKE '$age' ORDER BY `contacts`.`first_name` ASC LIMIT 0, 30 ";    
    
    $result = mysql_query($query);
    $num = mysql_num_rows ($result);
    mysql_close();

    if ($num > 0 ) {
        $i=0;
        while ($i < $num) {
            $first_name = mysql_result($result,$i,"first_name");
            $last_name = mysql_result($result,$i,"last_name");
            $age = mysql_result($result,$i,"age");
            $id = mysql_result($result,$i,"id");   

            echo "<b>first name:</b> $first_name<br>";
            echo "<b>last name:</b> $last_name<br>";
            echo "<b>age:</b> $age<br>";
            echo "<a href=\"update.php?id=$id\">Update</a> - <a href=\"delete.php?id=$id\">Delete</a>";
            echo "<br><br>";  

            ++$i; } } else { echo "No Results"; }?>

Link to comment
https://forums.phpfreaks.com/topic/227783-pagination/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.