View Single Post
  #3  
Old 15th July 2006, 12:26
SupuS SupuS is offline
HowtoForge Supporter
 
Join Date: May 2006
Posts: 202
Thanks: 68
Thanked 14 Times in 12 Posts
Default

Hi

I have mysql 5 and horde 3.1.2 and your script doesn't work for me as it should .. sql query:

Code:
$query  = 'SELECT user_email,domain_domain FROM (isp_isp_user INNER JOIN isp_dep ON (isp_isp_user.doc_id=child_doc_id AND isp_isp_user.doctype_id=child_doctype_id))';
    $query .= ' INNER JOIN isp_isp_domain ON (parent_doc_id=isp_isp_domain.doc_id AND parent_doctype_id=isp_isp_domain.doctype_id) WHERE user_username=' . $db->quote($user);
    $result =& $db->query($query);
returns 0 rows so if I want to send mail I see this query instead of email adress.

I'm not so good in sql lang and I am not able to find the thing what can resolve this problem. Any hints please?

Little note: in new version of horde I had to add

Code:
require_once 'DB.php';
before

Code:
$db =& DB::connect($dsn, true);
Reply With Quote