[Typo3-dev] Newbie:Getting value from another table

[Georg Ringer]

Hello Franz,

I went i little bit on and got now an other problem. I'm using the existing
function pi_list_row($c) to test  and it looks now like this:

 function pi_list_row($c) {
  $query='SELECT * FROM tx_rgzitate_autor, tx_rgzitate_zitat '.' where
tx_rgzitate_zitat.autorz = tx_rgzitate_autor.uid'.' AND hidden=0 AND
deleted=0 ';
  $res = $GLOBALS['TYPO3_DB']->sql(TYPO3_db, $query);

  return '<tr'.($c%2 ? $this->pi_classParam("listrow-odd") : "").'>
    <td valign="top"><p>'.$this->getFieldContent("autor").'</p></td>
   </tr>';
 }

I do get results for all the columns of tx_rgzitate_zitat but I don't get a
result for "autor" :(
The query is 100% correct.

many thanks for your help!
georg