1. Hugh is now back at work, more or less full time, after a slower than expected recovery from his neck surgery early this month. Obviously we have a backlog of support to clear, and are working as hard as we can to take care of it. If you have an unanswered thread more than 3 days old, please post one (and only one) "bump" on it, to move it in to our "last 3 days" list. If you have an unanswered issue in a forum you no longer have access to due to subscriptions timing out, please use the Contact Us form, and provide us with the URL to the thread.

How to retrieve values from another form and use as the default valuel for a field

Discussion in 'Subscriber Support' started by steemer473, Dec 19, 2010.

  1. steemer473 Member

    Level: Community
    I am trying to retrieve values from Form B in order to prepopulate Form A. I am not a programmer so please bear with me. Below is the php code I am using.

    $db = JFactory::getDBO();
    $user = JFactory::getUser();
    $userid = $user->get('id');
    $db->setQuery("
    SELECT jos_Agents.agent_type
    FROM `jos_Agents` WHERE jos_RFC.user_id =$userid");
    $results = $db->loadResult();
    return $results;

    This code is what I am using to retrieve the value of the agent_type field. When I load the form, the field is blank. I'm not seeing what is wrong with this expression. Can you identify why this isn't working
  2. rob Administrator

    Level: Community
    looks correct to me.
    After your $db->setQUeyr();

    add

    echo $db->getQuery();exit;

    to see what the query is that is being run.
    Then paste that into phpMyAdmin to see whether an error is reported or if the data is correctly returned.

Share This Page