Dreamweaver Database table not showing

[bombardos]

I'm stumped, can someone share their wisdom with me please?

I'm running Dreamweaver mx2004 on WinXP, creating a site using php with
phpMyAdmin 2.7.0 for the sql.
Connection is all fine for the site, have created 3 tables within the database
which all show up fine in the Application > Databases panel of dreamweaver.
The problem arrose when I created the 4th table called orders in the same
database as the rest. Dreamweaver does not want to show the tables fields in
the Databases panel, and I have no idea why.

Loading Image...

[Baxter]

I believe Order is a reserved word and can not be used for a table in MYSQL
Try myorders or something like that.
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
Dave

Post by bombardos
I'm stumped, can someone share their wisdom with me please?
I'm running Dreamweaver mx2004 on WinXP, creating a site using php with
phpMyAdmin 2.7.0 for the sql.
Connection is all fine for the site, have created 3 tables within the database
which all show up fine in the Application > Databases panel of

dreamweaver.

Post by bombardos
The problem arrose when I created the 4th table called orders in the same
database as the rest. Dreamweaver does not want to show the tables fields in
the Databases panel, and I have no idea why.
http://croc.ftw.net.nz/Screens/datatable.jpg

[bombardos]

Well done, thanks very much for that.

[Baxter]

Your Welcome
Dave

Post by bombardos
Well done, thanks very much for that.