I am having a lot of trouble with this...
I am using PHP/MySQL. What I have is a dating website. One of the tables in the database is called "users" which has many fields in it, storing the usual info (id, name, email, etc).
What I want to do is this:
When you view a member's profile, I want to display the value of the field called "compat" from the users table. The value of compat is unique for each member (well, not unique, but it varies greatly), so what I need is to make sure that "compat" is being displayed for the correct member.
I tried following some tutorials, but each one ends up displaying every single record contained in the "compat" field...I dont want that, I only want to display the user specific value.
If it helps, the member id is the unique key on the table...so I know that when I perform this query, I should get the profile's id and compat values to ensure the correct value appears, I just cant figure out how to code this.