i have a problem with my query. any body give suggestion please.
i have two tables named as "users" and "userimages"
in the users table there are
1)userid (primary key)
3)subscription package (Brong or gold)
and in the next table "userimages" fields are
2)userid (foreign key)
now i want to display users order by "subscription packages" and display whose image urls are not null those user profiles display first.