从mysql数据库中获取3个数据

Question

I am wondering how to get 3 data out from database with this example:

    $query->select(array('Name','Pos1','Pos2'))
    ->from($db->quoteName('#__regions'))
    ->where($db->quoteName('Name').'='.$_REQUEST['name']);

    $db->setQuery($query);
    $name = $db->loadResult();
    $pos1 = $db->loadResult();
    $pos2 = $db->loadResult();

I want to have data $name , $pos1 and $pos2. Or should i make code for each value i need? Thanks

Answer 1

change from

$query->select(array('Name','Pos1','Pos2'))
    ->from($db->quoteName('#__regions'))
    ->where($db->quoteName('Name').'='.$_REQUEST['name']);

    $db->setQuery($query);
    $name = $db->loadResult();
    $pos1 = $db->loadResult();
    $pos2 = $db->loadResult();

to

$query->select('Name','Pos1','Pos2')
    ->from($db->quoteName('#__regions'))
    ->where($db->quoteName('Name').'='.$_REQUEST['name']);

    $db->setQuery($query);
    $results = $db->loadObjectList();
    foreach ($results as $row) :
        $name =  $row->Name;
        $pos1 = $row->Pos1;
        $pos2 =  $row->Pos2;
    endforeach;