Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Normalization

Normalization

Thread began 6/13/2011 9:41 pm by madelectrical386948 | Last modified 6/30/2011 5:48 pm by madelectrical386948 | 3901 views | 33 replies

6/27/2011 6:16 ammadelectrical386948

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

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.