Assume that I have 1 current user id and second user id for which current user ........ ... if both have the same options then get mysql data .....
For example, User 1 has uploaded a picture and User 2 has also uploaded the photo ....... How can I match user1 to user2? Query should be like this ........
Choose from users * where id = 'user1id' or id = 'User2id' and imguploaded = '1'
whether this question is correct or not, but it is not working for me .......... !! I would like a working query, like * select from those users, such as imageddoded = 1
where brackets Due to preference with ...
select / pre> < P> If you do not, mysql will visualize the default priority and interpret the query in this way: and imguploaded = '1')
No damage will result.
To see that both users have actually uploaded a picture, which you can create:
select COUNT (*) As the count of users in the form where (id = 'user1id' or id = 'user2id') and imguploaded = '1'
and then check if count == 2
No comments:
Post a Comment