Hi

I have been at this for a while and have done all the reading I can but I cant get this to work.
I am pretty sure it is close so any help much appreciated.

I run the following sql from my database and it returns the info I require.

SELECT FieldValue FROM pzimy_rsform_submission_values WHERE FieldName = 'surname' AND SubmissionValueId = (select SubmissionId FROM pzimy_rsform_submissions WHERE UserId = '863' AND FormId = '4');


So I put this into the default value for a text field like this
//<code>
$db = JFactory::getDbo();
$db->setQuery("SELECT FieldValue FROM pzimy_rsform_submission_values WHERE FieldName = 'surname' AND SubmissionId = (select SubmissionId FROM pzimy_rsform_submissions WHERE UserId = '863' AND FormId = '4')";
return $db->loadResult();
//</code>

This returns nothing? Not sure what bis wrong but hoping it is close and possible.

Also wanting to use this for the UserId
JFactory::getUser()->id
will this return me the userid of the logged in user and just place it where I have 863? does it need leading . like this
.JFactory::getUser()->id.

Any assistance much appreciated
Paul