navigatie vraagje

// items van de huidige pagina ophalen
$offset = $huidige_pagina * $items_per_pagina;
$res2 = mysql_query("SELECT * FROM front ORDER BY id DESC LIMIT ".$offset.","
.$items_per_pagina) or die("res2:". mysql_error());

/*
doe hier iets met de gegevens in $res2
...
*/

// resultaten vrijgeven
mysql_free_result($res2);
 
$query = mysql_query("SELECT title,image,text FROM front");  
  while ($arr = mysql_fetch_row($query)) {  
    echo "" . $arr['0'] . ",";  
    echo "<img src=\" " . $arr['1'] . "\"><br />";  
  }  

// items van de huidige pagina ophalen
$offset = $huidige_pagina * $items_per_pagina;
$res2 = mysql_query("SELECT * FROM front ORDER BY id DESC LIMIT ".$offset.","
.$items_per_pagina) or die("res2:". mysql_error());
 
/*
doe hier iets met de gegevens in $res2
...
*/
 
// resultaten vrijgeven
mysql_free_result($res2);
 
$query = mysql_query("SELECT title,image,text FROM front");  
  while ($arr = mysql_fetch_row($query)) {  
    echo "" . $arr['0'] . ",";  
    echo "<img src=\" " . $arr['1'] . "\"><br />";  
  }

  while ($arr = mysql_fetch_row($res2)) {  
    echo "" . $arr['0'] . ",";  
    echo "<img src=\" " . $arr['1'] . "\"><br />";  
  }

while ($arr = mysql_fetch_row($res2)) {  
    echo "" . $arr['0'] . ",";  
    echo "<img src=\" " . $arr['1'] . "\"><br />";  
  }