Sunday, 15 March 2015

getting same property from mysql with php -


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 ... where user (id = 'user idid' or id = 'user idid') and imgolded = '1'

  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