Hi, i was wondering if you could give me some help with regards to getting data from two tables in the model view e.g. i have a list view wich has a user_id for each entry. I need to use that user_id to display the username by pulling the username out of the #__users table within joomla itself. how would i go about doing this, I have attached some images to help explain.



please help im guessing its not that hard i just dont understand how the querys are constructed in the model.

If you drag what is essentially the same field onto the grid, but instead of selecting the parent node (users), expand it and select the username, name, email or any other field available form users' table.

hope it helps,

Gez

Hi thanks for the reply although i still dont quite understand i think my main problem lies with acctually querying two databases in one model view,
I have a few questions regarding this auto generated code that if answered may help me on my way:

a) In the text highlighted in red (below) does the 'AS a' assign that table to the alias of 'a'?
b) Where/How do i add my WHERE query?
c) How do I reference another table and query it within this code dependant on a competitonID from the table being refrenced?

I should add that this is from an item view not a list view anymore.

---

function _buildQuery()
{

if (isset($this->_active))
switch($this->_active)
{
case 'entriesitem': return $this->_buildQuery_entriesitem(); break;

}



$query = 'SELECT a.*'
. $this->_buildQuerySelect()

. ' FROM `#__spotit_entries` AS a'
. $this->_buildQueryJoin()

. $this->_buildQueryWhere()

. '';

return $query;
}

function _buildQuery_entriesitem()
{

$query = 'SELECT a.*'
. $this->_buildQuerySelect()

. ' FROM `#__spotit_entries` AS a'
. $this->_buildQueryJoin()

. $this->_buildQueryWhere()

. '';

return $query;
}



function _buildQueryWhere($where = array())
{
$app = JFactory::getApplication();
$acl = SpotitHelper::getAcl();

$where[] = 'a.id = '.(int) $this->_id;



return parent::_buildQueryWhere($where);
}

---

Thanks once again any help is appreciated.

Turn to V2.0 to play with where if you can. It is MUCH easier.

If not :

In the caller (VIEW, almost of the cases)
$model->addWhere('a.myField = xxx');

xxx must be quoted or escaping, you know that.

You have your answer for 'a'.
'a' is always regresenting the main entry point table of your context model.

Hope it helps.

Last message until monday, I think.
Have a nice Week end.