Что бы если выводимой информации из бд было больше 10, что бы разбивало на страницы. Ну ни как не получается :(
Мой код:
<?php
include 'Connect.php';
$id = $_POST['id'];
$name = $_POST['name'];
$surname = $_POST['surname'];
$patronymic = $_POST['patronymic'];
$birthday = $_POST['birthday'];
$address = $_POST['address'];
$phone = $_POST['phone'];
$result=mysql_query('SELECT id, surname, name, patronymic, DATE_FORMAT(birthday,"%d-%m-%Y") AS date, address, phone FROM people where surname LIKE "%'.$surname.'%"
and name LIKE "%'.$name.'%" and patronymic LIKE "%'.$patronymic.'%" and phone LIKE "%'.$phone.'%" and address LIKE "%'.$address.'%" order by surname, name');
$num=1;
while($row=mysql_fetch_array($result))
{
$id = $row['id'];
echo '<table class="Find_table"><tr><td class="num"> ',$num++,'.</td><td>'.$row['surname'].'</td><td>'.$row['name'].'</td><td>'.$row['patronymic'].'</td>
<td>'.$row['date'].'</td><td>'.$row['address'].'</td><td>'.$row['phone'].'</td><td class="action">
<a href="Edit.php?_id='.$row['id'].'"><img class="edit" src="../Style/edit.png"></a>
<a href="Delete.php?_id='.$row['id'].'"><img class="delete" src="../Style/delete.jpg"></a>
</td></tr></table>';
}
mysql_close();
?>