1. Hugh is (technically) on vacation for the rest of September, travelling to Europe for his son's wedding in England, and to meet up with Rob in La Rochelle, France. He will be checking the forums most days, and providing some support, but his time will be limited, and he will be unable to do any custom coding work. Apologies in advance for any inconvenience.

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

    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');
    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

    rob Administrator Staff Member

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


    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