|
= $aantalrijen){
$Infopnl=0;
}
if($Infopnl < 0){
$Infopnl= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT ptitlenl FROM referentie WHERE ID =$IDIndexFile[$Infopnl] AND Status IN (1,2)";
}else{
$sql="SELECT ptitlenl FROM referentie WHERE ID =-1 AND Status IN (1,2)";
}
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
$row = mysql_fetch_array($result);
if(substr($row[0],0,7)=="||img||"){
//hier
// $imgname = "../images/";
// $imgname .= substr($row[0],7);
$imgname = substr($row[0],7);
echo $imgname;
// echo " ";
}else{
echo $row[0];
}
}
?>" border="0">
|
{
if($Refnl=="") $Refnl=0;
//creatie index-array voor browsing, wordt slechts 1 maal per pagina gecreëerd, hence de ==null
if($IDIndexFile==null){
$IDIndexFile=array();
$sql = "SELECT ID from referentie WHERE Status IN (1,2) ORDER BY ID";
$result = mysql_query($sql);
$aantalrijen = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
array_push($IDIndexFile,$row[0]);
}
}
if($Refnl >= $aantalrijen){
$Refnl=0;
}
if($Refnl < 0){
$Refnl= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT Refnl FROM referentie WHERE ID =$IDIndexFile[$Refnl] AND Status IN (1,2)";
}else{
$sql="SELECT Refnl FROM referentie WHERE ID =-1 AND Status IN (1,2)";
}
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
$row = mysql_fetch_array($result);
if(substr($row[0],0,7)=="||img||"){
//hier
// $imgname = "../images/";
// $imgname .= substr($row[0],7);
$imgname = substr($row[0],7);
echo $imgname;
// echo " ";
}else{
echo $row[0];
}
}
?>
lnkbar(3); ?>
|
|
|