Member Avatar for adeeb.keyaam

suppose i have a account in a website, and i want to see the users who are members of this website, and my name is also listed there, but i want to remove my name from there, from my account, i can see others name without mine, and this will happen for others account too, they will see others account but not him/herself.

SELECT * EXCEPT $login_user

please give me ideas or suggestions to make this idea into reality.
advance thanx to all who read this discussion and give their valuable time in here.

  • 2 Contributors
  • 6 Replies
  • 148 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by iamthwee

Recommended Answers

All 6 Replies

Member Avatar for iamthwee

Yes it is possible.

Member Avatar for adeeb.keyaam

then please help me to solve...

Member Avatar for adeeb.keyaam

thanx for your reply and suggestion, i will try for this and let you know about my progress on this problem...

Member Avatar for adeeb.keyaam

thanx for your suggestion iamthwee problem is solved using "SELECT * FROMtablenameWHEREcolumnnameNOT LIKE '%{$variablename}%'".

Member Avatar for iamthwee

Assuming logins are unique using the '%' operator is not needed.

Not only that you may have another user with their name inside another so this is subject to bugs/issues. In my opinion the username should be the primary key, or unique.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.