f_id int(50) PK not null autoincriment
foto_url varchar(255) not null

$link = mysql_connect('твой_сервер_БД','пол ьзователь','пароль');
mysql_select_db('имя_БД');

if ($_GET['first_view'] == "" or $_GET['last_view'] == "") {
$_GET['first_view'] == 0;
$_GET['last_view'] == 10;
}

$res = mysql_query("SELECT * FROM foto LIMIT ".intval($_GET['first_view'])." ,".intval($_GET['last_view']).";");
while($row = mysql_fetch_assoc($res)){
echo "<img src='".$row['foto']."'><br>";
}

$q = mysql_query("SELECT COUNT(*) FROM foto ");
$temp[0] = mysql_fetch_array($q);

if ($temp[0] > $_GET['last_view']) {
echo "<a href="этот_файл.php?first_view=10&last_vie w=20">next</a>";
}