{
if($infopar1nl=="") $infopar1nl=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 itsolution 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($infopar1nl >= $aantalrijen){
$infopar1nl=0;
}
if($infopar1nl < 0){
$infopar1nl= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT infopar1nl FROM itsolution WHERE ID =$IDIndexFile[$infopar1nl] AND Status IN (1,2)";
}else{
$sql="SELECT infopar1nl FROM itsolution 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];
}
}
?>
{
if($infopar2nl=="") $infopar2nl=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 itsolution 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($infopar2nl >= $aantalrijen){
$infopar2nl=0;
}
if($infopar2nl < 0){
$infopar2nl= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT infopar2nl FROM itsolution WHERE ID =$IDIndexFile[$infopar2nl] AND Status IN (1,2)";
}else{
$sql="SELECT infopar2nl FROM itsolution 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];
}
}
?>