Hi Jenny,
Give me a day or so before you look.
The biggest problem was the optionstable. The options OP1-OP4 or how many options you have must be unique. So OP1 must only have 1 in the data and so on. I was putting different numbers from 1,2 and 3 and mixing them. Not a good idea.
I found some good notes and procedures on Tom Muck's webpage and the MX community. That helped also with the alias understanding.
I need to redo the database again, so it's easier to read. Remove the stupid tables on the end of the table name. Make my life easier with the queries.
Also, doing the query right on the phpmyadmin screen also helps before you do it on with dreamweaver.
So, please let me know what the AS operator is. I believe you are just replacing real optionstable with a fake. Can you please explain that concept?
Thx
Mike Davis