hI,
I am running PHP, MySQL on Mac OSX 10.3.4 and using Dreamweaver MX 2004. I have created a DB connection to my MySQL DB and created 3 tables within my DB. Everything EXCEPT the following sems to be working nominally. I can identify (see), and use all fields within all three tables EXCEPT a field called perm_num (int 11, NOT NULL) in one of the tables. Curiously, the field shows up in the SIMPLE connection query box when I click and open the tables but DOES NOT show up in the ADVANCED query connection pop-up bow ---why?? Additionally I do not seem to be able to JOIN ANY of the three tables in the ADVANCED query box...When I do a WHERE statement an error dialog comes up and tells me it "cannot find the table requested" any ideas??.....Everything other query statement and procedure seems to be working correctly...Any help would be greatly appreciated...

Looks like your running into the same wall that I was a few years back. When it comes to letting DW do DB automation it's ok when the queries are on a simple smaller scale. When you graduate to more complexed queries you'll find that DW will spit out all sorts of errors, javascript errors to be more exact. You did know that DW works on Javacript right? Anyways, so it was best for me to hand code complicated DB applications and use DW DB automation only for more simple task.

In other words, stop using WYSIWYG for complexed applications. They should and usually are too complexed for an automated sofware package to build. Go to code view and do it by hand. If you can't do it by hand.. well, you should be doing any developing because you can't understand how things work under the hood should something need modifying, replaceing, or fixing.