尝试添加if条件以执行以下操作
1-根据用户之前选择的数据选择数据
2-根据所有用户选择数据的时间来选择数据。
3-设置所有用户可选择数据的最大次数。
下面是我的当前代码,您可以看到我所做的第一个条件,它工作得很好
$sql=mysql_query(
"SELECT courseid,coursename
FROM newcourses
where (courseid not in (select courseid from applicants)
)"
);例如:如果我有具有这些行的表新课程
courseid coursename max applicant
1 English standard 3
2 English advance 2
3 Spanish 4表申请者拥有以下行
id name courseid
1 me 1
2 jon 1
3 jake 2
4 sara 2
5 joe 3那么怎么做呢?
发布于 2013-10-19 22:36:39
必须使用筛选器(如按拥有组)来包含子查询中的所有负行。
SELECT courseid, coursename
FROM newcourses
WHERE courseid NOT IN (SELECT courseid FROM applicants GROUP BY courseid HAVING COUNT(courseid) > 1)易读:
SELECT courseid, coursename
FROM newcourses
WHERE courseid IN (SELECT courseid FROM applicants GROUP BY courseid HAVING COUNT(courseid) = 1)发布于 2013-10-19 22:58:11
这就是你想做的吗?
$sql = mysql_query(
"SELECT courseid,coursename
FROM newcourses
WHERE (courseid NOT IN (SELECT courseid FROM applicants GROUP BY courseid HAVING( COUNT( courseid ) > 1)))
"
);“拥有(计算(课程)>1)”将返回表“申请者”的多次锁定值。
发布于 2013-10-19 22:13:48
SELECT courseid,coursename
FROM newcourses
where courseid not in (select courseid from applicants GROUP BY courseid HAVING COUNT(courseid)=2)如果您想忽略属于三胞胎或更多的课程,请使用HAVING COUNT(courseid)>1
https://stackoverflow.com/questions/19471703
复制相似问题