如何使用电子邮件验证

Question

我需要一个查询来选择ID，因此进入的问题之前，我将介绍数据库设计从jom_community_users

• Table Name- jom_community_users 
  
  id || name || username || email || password || usertype || block || sendEmail 
  ------------------------------------------------------------------------------- 
  799 aaaa aaaa.bbbb [email protected] xxttxyyb Registered  1   0 
  ------------------------------------------------------------------------------- 
  800 xxxx xxxx.yyyy [email protected] aabbxtta Registered  1   0  
  
  Table Name- jom_community_invit 
  
  from_id || to_email || point_given 
  ----------------------------------- 
  799  [email protected]   1 
  

  选择id其中在该表中的电子邮件是相等在jom_community_invit表to_email给出的应该是一个在jom_community_invit表

• 点

Answer 1

不知道这是你是什么，但之后：

SELECT CU.id 
FROM jom_community_users CU,jom_community_invit CI 
WHERE CU.email = CI.to_email 
AND CI.point_given = 1 

如前所述，我希望这是你所要求的东西。

Answer 2

你的意思是：如果

 

$query = 'SELECT cu.id FROM #__community_users cu , #__community_invit ci 
    WHERE cu.email = ci.to_email AND ci.point_given = 1'; 

//OR 

$query = "SELECT cu.id FROM #__community_users cu JOIN #__community_invit ci 
    ON(cu.email = ci.to_email AND ci.point_given='1') 
    WHERE cu.email = ".$db->Quote($yourEmail); 

$db->setQuery($query); 
 

Answer 3

试试这个：

SELECT * 
FROM #_community_users a 
INNER JOIN #_community_invit b 
ON a.email = b.to_email where b.point_given=1 

Answer 4

尝试

Select id 
from jom_community_users, jom_community_invit 
where jom_community_users.email = jom_community_invit.to_email 
and jom_community_invit.pont_given = 1