Er zit een fout in de query:<br><b>
			SELECT r.*, type.name sn_typedesc,c.name city,s.name suburb,s.handvat shandvat,c.handvat chandvat
			FROM accommodation r
			INNER JOIN city c ON (r.city_id=c.id)
			LEFT JOIN suburb s ON (r.suburb_id=s.id)
			LEFT JOIN sn_typedesc type ON (type.id=r.sn_typedesc)
			WHERE 
				r.handvat='pa-pa-giovannis-bb' AND 
				r.active='ja' AND 
				r.deleted!='ja' AND c.handvat = 'johannesburg' </b><br>De fout is:<b><br>Unknown column 'r.active' in 'where clause'</b><br><br><pre>Array
(
    [0] => Array
        (
            [file] => /home/httpd/vhosts/wc2010accommodations.com/httpdocs/inc/sql.inc.php
            [line] => 5
            [function] => sql_error
            [args] => Array
                (
                    [0] => 
			SELECT r.*, type.name sn_typedesc,c.name city,s.name suburb,s.handvat shandvat,c.handvat chandvat
			FROM accommodation r
			INNER JOIN city c ON (r.city_id=c.id)
			LEFT JOIN suburb s ON (r.suburb_id=s.id)
			LEFT JOIN sn_typedesc type ON (type.id=r.sn_typedesc)
			WHERE 
				r.handvat='pa-pa-giovannis-bb' AND 
				r.active='ja' AND 
				r.deleted!='ja' AND c.handvat = 'johannesburg' 
                )

        )

    [1] => Array
        (
            [file] => /home/httpd/vhosts/wc2010accommodations.com/httpdocs/inc/custom.func.php
            [line] => 636
            [function] => query
            [args] => Array
                (
                    [0] => 
			SELECT r.*, type.name sn_typedesc,c.name city,s.name suburb,s.handvat shandvat,c.handvat chandvat
			FROM accommodation r
			INNER JOIN city c ON (r.city_id=c.id)
			LEFT JOIN suburb s ON (r.suburb_id=s.id)
			LEFT JOIN sn_typedesc type ON (type.id=r.sn_typedesc)
			WHERE 
				r.handvat='pa-pa-giovannis-bb' AND 
				r.active='ja' AND 
				r.deleted!='ja' AND c.handvat = 'johannesburg' 
                )

        )

    [2] => Array
        (
            [file] => /home/httpd/vhosts/wc2010accommodations.com/httpdocs/inc/site/accommodation.inc.php
            [line] => 4
            [function] => getAccommodation
            [args] => Array
                (
                    [0] => pa-pa-giovannis-bb
                    [1] => johannesburg
                )

        )

    [3] => Array
        (
            [file] => /home/httpd/vhosts/wc2010accommodations.com/httpdocs/inc/fun.inc.php
            [line] => 341
            [args] => Array
                (
                    [0] => /home/httpd/vhosts/wc2010accommodations.com/httpdocs/inc/site/accommodation.inc.php
                )

            [function] => require_once
        )

    [4] => Array
        (
            [file] => /home/httpd/vhosts/wc2010accommodations.com/httpdocs/index.php
            [line] => 68
            [function] => returnIncludeFile
            [args] => Array
                (
                    [0] => inc/site/accommodation.inc.php
                )

        )

)