 PHP expert |
|
je moet met LIMIT werken in je query
<?
$aantal = 10; //stuks per pagina
$limit_begin = ( isset( $_GET['page'] ) === true && empty( $_GET['page'] === false && is_numeric( $_GET['page'] ) === true ) ? $_GET['page'] * $aantal : 0;
$limit_stop = ( isset( $_GET['page'] ) === true && empty( $_GET['page'] === false && is_numeric( $_GET['page'] ) === true ) ? ( $_GET['page'] * $aantal ) + ( $aantal - 1 ) : $aantal - 1;
?>
<? $aantal = 10; //stuks per pagina $limit_begin = ( isset( $_GET['page'] ) === true && empty( $_GET['page'] === false && is_numeric( $_GET['page'] ) === true ) ? $_GET['page'] * $aantal : 0; $limit_stop = ( isset( $_GET['page'] ) === true && empty( $_GET['page'] === false && is_numeric( $_GET['page'] ) === true ) ? ( $_GET['page'] * $aantal ) + ( $aantal - 1 ) : $aantal - 1; ?>
dan in je query op het einde:
<?
mysql_query(".... LIMIT " . $limit_begin . " , " . $limit_stop ."") or die(mysql_error());
?>
snappie?  |
Wat is jouw favoriete javascript framework? (S: 18, R: 2)
Gesponsorde links
Actiefste leden van de maand
