<?php

$db = JFactory::getDbo();

$query = $db->getQuery(true);

$query = "SELECT max(submission_id) FROM #__jsn_uniform_submissions;";

$db->setQuery($query);

$results = $db->loadRow();

$results = array_shift($results);

//echo 'submission_start'.$results.'submission_end';

$query = "SELECT submission_data_value from #__jsn_uniform_submission_data where field_type='file-upload'and submission_id=$results;";

$db->setQuery($query);

$results = $db->loadRow();

$results = array_shift($results);

$results = json_decode($results);

$results = array_shift($results);

//print_r($results);

echo 'name_start'.$results->name.'name_end';

echo 'link_start'.$results->link.'link_end';

?>