hi, im doing a kind of social network program where users can login to add freinds, etc etc.. and now im doing the privacy section where user can choose to display their name,age,gender etc etc to certain group of people, example to friends only, friends of friends etc.. im thinking of creating a table call "privacy" where they have fields like "display_name", "display_gender", etc.. afterwhich i would join user table with privacy table and check. i understand if my sql doesnt meet the criterial, it will not return the row. how can i do my sql in such a way whereby if it dun meet the criteria, return a empty field. let say user john has choose not to display his gender, so return the row but null for gender's field??
does it make sense??😕
feel free to post ur answers or questions =)
