[insert_php]

global $wpdb;

$brain_id = $_GET[‘brain_id’];
$label = $_GET[‘label’];

$results = $wpdb->get_results(“SELECT Navigator_section.jp2Image FROM Navigator_section WHERE Navigator_section.brain_id=$brain_id AND Navigator_section.label=’$label’ AND Navigator_section.isDamaged=0 AND Navigator_section.reImage=0 ORDER BY Navigator_section.slideIndex ASC”);

$new_images = array();
if ($results) {
foreach ($results as $row) {
$new_images[] = $row->jp2Image;
}
}

if($label == ‘N’){
$video_results = $wpdb->get_results(“SELECT Navigator_video.video_link FROM Navigator_video WHERE Navigator_video.brain_id=$brain_id AND Navigator_video.label=’$label'”);

$new_video = array();
if ($video_results) {
foreach ($video_results as $row) {
$new_video[] = $row->video_link;
}
echo do_shortcode(“

‘;
}
}

echo do_shortcode(“

foreach($new_images as $image) {
$image_link = explode(‘||’, $image);
$less_image = explode(‘.jp2’,$image_link[0]);
echo ‘‘;
echo ‘‘;
}
[/insert_php]