if(!isset($_GET['pagina']) || $_GET['pagina'] =='')
{
$pagina ='home';
}
else
{
$pagina =mysql_real_escape_string($_GET['pagina']);
}

//mainsql
$maintekst=false;
$mainqry = " 
                SELECT 
                        titel,
                        url,
                        tekst, 
                        link,
                        include,
                        taal,
                        taalbestand
                FROM 
                        jcsl
                INNER JOIN
                        jcsl_tekst
                ON
                        jcsl.id=jcsl_tekst.url
                WHERE
                        taal='".$lang."' 
                AND     
                        link = '" . $pagina ."'
            ";
            

    $mainsql = mysql_query($mainqry, $connection); 
    
    if($mainsql === false)
    {
        echo (" Er gaat iets mis in (".$mainqry .")".mysql_error($connection));
    }                
    else
    {
        $maintekst = mysql_fetch_assoc($mainsql); 
    }

            
if($maintekst==false)
{ 
    $mainaltqry    = " 
                        SELECT 
                               titel, 
                               tekst
                        FROM 
                               jcsl
                        INNER JOIN
                                jcsl_tekst
                        ON
                                jcsl.id=jcsl_tekst.url
                        WHERE 
                                taal='".$lang."' 
                        AND     
                               link= 'error404'
                               "; 
        $mainaltsql = mysql_query($mainaltqry, $connection); 
    
    if($mainaltsql === false)
    {
        echo (" Er gaat iets mis in (".$mainaltqry .")".mysql_error($connection));
    }                
    else
    {
        $maintekst = mysql_fetch_assoc($mainaltsql); 
    }
}

][<?php
$con = mysql_connect("****","****","****");
if (!$con)
  {  die('Could not connect: ' . mysql_error());  }
mysql_select_db("****", $con);

$query = "UPDATE naamtabel
SET
 datum_kantinedienst = 'augustus' // nieuwe datum
WHERE
 naam_kantinedienst = 'Andre'"; // gewijzigd bij Andre

mysql_query($query) or die (mysql_error());
mysql_close($con);

?>

$visited_array = array(1,2,3,4,5,6,7,8,9,10);

$id = mysql_result(mysql_query("SELECT id FROM sites WHERE id!='".$visited_array."' ORDER BY waarde DESC LIMIT 1"),"id");

$m = preg_match_all('/http:\/\/[a-z0-9A-Z,-.]+(?(?=[\/])(.*))/', $reactietxtstrip, $match);

if ($m) {
    $links=$match[0];
    for ($j=0;$j<$m;$j++) {
        $reactietxtstrip=str_replace($links[$j],'<a href="'.$links[$j].'" target="_blank">'. inkorten($links[$j], 40) .'</a>',$reactietxtstrip);
    }
}

<?php

class SimpleImage {
 
   var $image;
   var $image_type;
   var $orgWidth;
   var $orgHeight;
 
   function __construct($filename) {
 
      $image_info = getimagesize($filename);
      $this->image_type = $image_info[2];
      
      if( $this->image_type == IMAGETYPE_JPEG ) {
 
         $this->image = imagecreatefromjpeg($filename);
      } elseif( $this->image_type == IMAGETYPE_GIF ) {
 
         $this->image = imagecreatefromgif($filename);
      } elseif( $this->image_type == IMAGETYPE_PNG ) {
 
         $this->image = imagecreatefrompng($filename);
      }
   }
         
   function output() {
 
      imagejpeg($this->image);

   }
   
   function scale($scale) {
      $this->orgWidth = imagesx($this->image);
         $this->orgHeight = imagesy($this->image);      
                    
      $width = $this->orgWidth * $scale/100;
      $height = $this->orgHeight * $scale/100;
      $this->resize($width,$height);
   }
 
   function resize($width,$height) {
      $new_image = imagecreatetruecolor($width, $height);
      imagecopyresampled($new_image, $this->image, 0, 0, 0, 0, $width, $height, $this->orgWidth, $this->orgHeight);
      $this->image = $new_image;
   }       
 
}

      $image = new SimpleImage('http://smbjorklund.no/sites/smbjorklund.no/files/pictures/1/apple_mac_os_x_10.5_leopard_1024x768_1.jpg');
       $image->scale(50);
       $image->output();
       unset ($image);
       
// tweede plaatje, deze doet het niet

      $image1 = new SimpleImage('http://smbjorklund.no/sites/smbjorklund.no/files/pictures/1/snow-leopard1.jpg');
       $image1->scale(50);
       $image1->output();
       unset ($image1);
  ?>

+----+------------+-------+
| ID | Datum      | Stand |
+----+------------+-------+
|  1 | 2011-03-01 | 23175 |
|  2 | 2011-04-01 | 23312 |
|  3 | 2011-05-01 | 23389 |
+----+------------+-------+

+----+------------+-------+-------+
| ID | Datum      | Begin | Eind  | 
+----+------------+-------+-------+
|  1 | 2011-03-01 | 23175 | 23175 |
|  2 | 2011-04-01 | 23312 | 23312 |
|  3 | 2011-05-01 |     0 | 23389 |
|  4 | 2011-06-01 |    12 |    12 |
+----+------------+-------+-------+

Options FollowSymLinks MultiViews

RewriteEngine On
RewriteCond %{REQUEST_URI} !style.css
RewriteCond %{REQUEST_URI} !/beheer
RewriteRule ^([^/]+)$ index/$1 [NC,L]