Question

浏览器有1个现有用户,还有另一个用户,目前用户正在访问。

例如,用户1已上下了照片,用户2也上下了照片。

* 选自用户:id=用户1id或id=用户2id 和免疫有效载荷= 页: 1

is this query is correct or not but it is not working for me..........!! i want a working query same as above not as select * from users where imguploaded=1

Answer 1

由于优先程度,试图将你带括号的顺序排列在后面......

select * from users where (id= user1id  or id= user2id ) and imguploaded= 1

如果你不 t我的q,就会把 default事摆在优先地位,并像这样解释问题:

select * from users where id= user1id  or (id= user2id  and imguploaded= 1 )

这将不产生预期结果。

检查用户是否实际上下了照片,可以做到:

select COUNT(*) as count from users where (id= user1id  or id= user2id ) and imguploaded= 1

之后,如果计算=2

Answer 2

为什么你们想要这样的东西?

任何方面......都会形成某种行动表,如<编码>、行动、。然后创建<代码>用户_action。表格如<代码>id,用户_id,行动_id。然后,请你取得成果。

因此,你储存数据指的是表格,而不是用其行动数据提升用户数据。这样,你也能够方便地扩大行动范围,比较采取行动的使用者。

Answer 3

select * from users where (id= user1id  and imguploaded= 1 ) and (id= user2id and imguploaded= 1 )

Answer 4

如何加入?

query = "SELECT * FROM users AS first JOIN users AS second ON first.imguploaded = second.imguploaded WHERE first.userid = $user1 AND second.userid = $user2"

This query would take the two users, and if they have the same attribute (imguploaded is the same for both), return both rows, you can then select what you need. You can add more attributes to the ON clause, for example: ON first.imguploaded = second.imguploaded OR ( first.imgdloaded = second.imgdloaded AND first.somethingelseuploaded = second.somethingelseuploaded).

这样(加上我方言中的“ ON”条款),你就可以将一切属性合并起来,但你必须把括号(和)放在适当的位置。当然,如果你不提,MySQL服务器将只是按序读。

这是你们需要的吗?

友情链接