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"; }?>