|
= $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 contact WHERE ID =$IDIndexFile[$Infopnl] AND Status IN (1,2)";
}else{
$sql="SELECT ptitlenl FROM contact 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($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 contact 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 contact WHERE ID =$IDIndexFile[$infopar1nl] AND Status IN (1,2)";
}else{
$sql="SELECT infopar1nl FROM contact 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 contact 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 contact WHERE ID =$IDIndexFile[$infopar2nl] AND Status IN (1,2)";
}else{
$sql="SELECT infopar2nl FROM contact 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];
}
}
?>
|
|
|
= $aantalrijen){
$link1=0;
}
if($link1 < 0){
$link1= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT link1 FROM contact WHERE ID =$IDIndexFile[$link1] AND Status IN (1,2)";
}else{
$sql="SELECT link1 FROM contact 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];
}
}
?>"> = $aantalrijen){
$img1=0;
}
if($img1 < 0){
$img1= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT img1 FROM contact WHERE ID =$IDIndexFile[$img1] AND Status IN (1,2)";
}else{
$sql="SELECT img1 FROM contact 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">= $aantalrijen){
$link2=0;
}
if($link2 < 0){
$link2= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT link2 FROM contact WHERE ID =$IDIndexFile[$link2] AND Status IN (1,2)";
}else{
$sql="SELECT link2 FROM contact 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];
}
}
?>"> = $aantalrijen){
$img2=0;
}
if($img2 < 0){
$img2= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT img2 FROM contact WHERE ID =$IDIndexFile[$img2] AND Status IN (1,2)";
}else{
$sql="SELECT img2 FROM contact 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">= $aantalrijen){
$link3=0;
}
if($link3 < 0){
$link3= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT link3 FROM contact WHERE ID =$IDIndexFile[$link3] AND Status IN (1,2)";
}else{
$sql="SELECT link3 FROM contact 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];
}
}
?>"> = $aantalrijen){
$img3=0;
}
if($img3 < 0){
$img3= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT img3 FROM contact WHERE ID =$IDIndexFile[$img3] AND Status IN (1,2)";
}else{
$sql="SELECT img3 FROM contact 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">= $aantalrijen){
$link4=0;
}
if($link4 < 0){
$link4= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT link4 FROM contact WHERE ID =$IDIndexFile[$link4] AND Status IN (1,2)";
}else{
$sql="SELECT link4 FROM contact 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];
}
}
?>"> = $aantalrijen){
$img4=0;
}
if($img4 < 0){
$img4= $aantalrijen;
}
if(count($IDIndexFile)>0){ // 0 = er zijn geen rijen die mogen weergegeven worden
$sql = "SELECT img4 FROM contact WHERE ID =$IDIndexFile[$img4] AND Status IN (1,2)";
}else{
$sql="SELECT img4 FROM contact 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">
|
|
|