execute('SELECT * FROM `gallery` WHERE `galleryID` = "' . (int)$galleryid . '" LIMIT 1;'); if($sql->numrows>0){ $sql->results(); $gallery = $sql->data; } $sql->flush(); $query = 'SELECT * FROM `galleryitems` `gi` INNER JOIN `media` `m` ON `m`.`mediaID` = `gi`.`gi_mediaID` AND `m`.`m_soort` = "0" AND `m`.`m_actief` = "1" WHERE `gi`.`gi_galleryID` = "' . (int)$galleryid . '" ORDER BY `m`.`m_bestand`, `m`.`m_plaatsing_ts` DESC'; $sql->execute($query); $totaalnum = $sql->numrows; $sql->execute($query . ' LIMIT ' . $offset . ',' . $limit . ';'); $paginanum = $sql->numrows; if($paginanum>0){ $sql->results(); $foto = $sql->data; } $sql->flush(); ?> Yu Kun Yang, Expressionist Painter, Contemporary Painter

', /* 1 */ MEDIA_PATH, /* 2 */ stripslashes($foto[0]['m_bestand'])); } ?>
0){ printf('

%1$s

' . CRLF . '

Size : %2$s

' . CRLF . '

Discription : %3$s

' . CRLF . '

Availability : %4$s

' . CRLF . '

Price : € %5$s

', /* 1 */ stripslashes($foto[0]['m_naam']), /* 2 */ stripslashes($foto[0]['m_size']), /* 3 */ stripslashes($foto[0]['m_description']), /* 4 */ stripslashes($foto[0]['m_availability']), /* 5 */ stripslashes($foto[0]['m_price'])); } ?>