|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
I need to create a query to find users who belong to a particular secondary usergroup, but who do not currently have (or possibly never had) a certain paid subscription. PHP Code: SELECT user.userid, user.username FROM user, subscriptionlog WHERE user.userid = subscriptionlog.userid AND subscriptionlog.status !=1 AND ( FIND_IN_SET( "18", user.membergroupids ) ) ; Finds me those who have an expired paid subscription (regardless of whether or not there's a current subscription). Which is okay... but it won't find those people that don't have an entry in the subscription table at all. Any ideas? TIA __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |