Zeleo bih da te rezultate iz baze podelim na vise strana, recimo, 50 rezultata po strani sa linkovima (sledeca i predhodna stranica).
Ja sam tu i tamo nesto pokusavao ali bezuspesno, hvala unapred!
evo code-a:
Code:
<?php require_once('Connections/connDB.php'); ?>
<?php
mysql_select_db($database_connDB, $connDB);
$query_berzaRecordset = "SELECT id_radnici, ime, prezime, posao, rodjenje, pol, CHAR_LENGTH(cv) FROM radnici WHERE objavljeno = 'DA' ORDER BY prezime ASC";
$berzaRecordset = mysql_query($query_berzaRecordset, $connDB) or die(mysql_error());
$row_berzaRecordset = mysql_fetch_assoc($berzaRecordset);
$totalRows_berzaRecordset = mysql_num_rows($berzaRecordset);
?>
<?php echo $row_berzaRecordset['prezime']; ?> <?php echo $row_berzaRecordset['ime']; ?>
<?php echo $row_berzaRecordset['posao']; ?>
<?php echo $row_berzaRecordset['pol']; ?>
<?php echo $row_berzaRecordset['rodjenje']; ?>
<?php
if ($row_berzaRecordset['CHAR_LENGTH(cv)']>10){
print("<a href=\"berza_cv.php?id_cv={$row_berzaRecordset['id_radnici']}\" title=\"CV i dodatne informacije\">CV</a>");
//echo $row_berzaRecordset['CHAR_LENGTH(cv)'];
}
?>
<?php require_once('Connections/connDB.php'); ?>
<?php
mysql_select_db($database_connDB, $connDB);
$query_berzaRecordset = "SELECT id_radnici, ime, prezime, posao, rodjenje, pol, CHAR_LENGTH(cv) FROM radnici WHERE objavljeno = 'DA' ORDER BY prezime ASC";
$berzaRecordset = mysql_query($query_berzaRecordset, $connDB) or die(mysql_error());
$row_berzaRecordset = mysql_fetch_assoc($berzaRecordset);
$totalRows_berzaRecordset = mysql_num_rows($berzaRecordset);
?>
<?php echo $row_berzaRecordset['prezime']; ?> <?php echo $row_berzaRecordset['ime']; ?>
<?php echo $row_berzaRecordset['posao']; ?>
<?php echo $row_berzaRecordset['pol']; ?>
<?php echo $row_berzaRecordset['rodjenje']; ?>
<?php
if ($row_berzaRecordset['CHAR_LENGTH(cv)']>10){
print("<a href=\"berza_cv.php?id_cv={$row_berzaRecordset['id_radnici']}\" title=\"CV i dodatne informacije\">CV</a>");
//echo $row_berzaRecordset['CHAR_LENGTH(cv)'];
}
?>