database View can see tables but not columns! HALP!!!

[Mercutio2007]

ok the setting:

FreeBSD Server PHP MySQL technology using MX Kollection 3 .... Connection is working I can see all of the tables I can also see the columns in all of the tables EXCEPT one table that one i see the table but it shows NO data. I have deleted the table and rebuilt it several times ... attempted to optimize the table ..... Nothing works. However!! IF i look at the table data (right clicking the table and selecting view data) in that mystery table It shows all of the columns!! BUT not in the normal database view ...... Nor does it recognize colums when setting up ANY recordsets ..... I have gone bald .... a toupe will fix that ... but how do i fix this table!!???

[Guest]

did you ever get an answer on this one? I have the same issue exactly with a MySQL db

[Guest]

I am having problems with my mySQL / php database connection.... I am thinking about reinstalling Dreamweaver, I had my pc crash several times, maybe this will help... Does this sound reasonable to you?

[Guest]

Did a recent update to 7.01 and the problem was still there, so it is not addressed by that update. I would imagine the brainiacs in marketing at Macrodobe will not allow the support techs to help on this one...cause it probably doesnt exist as an issue with 8.0....

I dont have the ducats to upgrade right now...so hoping it is a minor fix. Anyone with ideas? I checked and doubledchecked all column names etc and inserts work fine using the phpAdmin tools from GoDaddy.

[Guest]

did you ever get an answer on this one? I have the same issue exactly with a MySQL db running on Godaddy.com servers. Can see table columns and data in "view data" mode, but not in any dialog boxes for setting up any DB interaction.