Re: [Vtigercrm-repository] [Vtigercrm-developers] Select queries

[John C. <jo...@re...>]

Finally got the answer myself but don't understand why !

John Crisp wrote:

> 
> $sql = "select accountname from vtiger_account, vtiger_contactdetails
> where vtiger_account.accountid = vtiger_contactdetails.accountid and
> vtiger_contactdetails.contactid =".$myctc_id;
>    $result = $adb->query($sql);
>    $the_acct_name = $adb->query_result($result,0,'accountname');
> 

The answer is changing SELECT accountname to SELECT *


Can anyone explain it ??
_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com