我如何...从两个表中获取多列信息?
问题描述:
此查询是否正确
is this query is right
SELECT username,password login_for_all.mis
FROM kvch_info_centre.member
INNER JOIN login_for_all ON kvch_info_centre.member.Activation_Code =login_for_all.Activation_Code where username='".$_POST['fname']."' and Password='".md5($_POST['pass'])."' and mis="Yes"
答
_POST [' fname ' ]。' 和密码= ' 。md5(
_POST['fname']."' and Password='".md5(
_POST [' pass ' ])。' 和 mis = 是
_POST['pass'])."' and mis="Yes"
您的查询必须以开头开头双引号
,最后一部分应该是
You query must have started with an opening double quote "
and the last part should be
mis='Yes'"