Originally Posted by andrwleong

Could you just help me understand this more thanks.

Understanding Answer 1
From my understanding of what you wrote. I keep my Database in Access and use MySQL to get the database and dreamweaver to interact?

Answer:
What I really mean was.. I keep my database/data in ACCESS or MySQL and use Dreamweaver as my text editor and connect them using a manual hard coded code to connect my ASP or PHP page to my database

Sorry if this confuse you. If it does, please let me know, ok?
Cheers...

Understanding Answer 2

A) On the above list lets say I only wanted to pull out all the people who are 'married' but only display their picture, name, age and material status?

Answer:
"SELECT picture, name, age, status FROM Tablename WHERE status = Married"

B) The same as above but only a specific person.

It is hard to explain but in question two. I would like the indavidual fields to show in the tables i have created in dreamweaver. I have attached a picture of an example table I would set out.

Answer:
"SELECT picture, name, age, status FROM Tablename WHERE status = 'Married' and Username = 'John'"