http://www.co-author.net/devnet/dreamweaver/articles/first_dynamic_site_pt3.html

http://www.co-author.net/devnet/dreamweaver/articles/first_dynamic_site_pt3.html.

Working with this tutorial and closely following the outline I get:

a MYSQL Error#: 1054

Unknown column 'news.update' in 'field list'

I downloaded the attach files and place them in my folder, removing my originals, and still get this error.

http://www.co-author.net/devnet/dreamweaver/articles/first_dynamic_site_pt3.html

SELECT DISTINCT DATE_FORMAT(news.updated, '%M %Y') AS archive

DATE_FORMAT(news.updated, '%Y-%m') AS link

FROM news

ORDER BY news.updated DESC

4. Create the Archives links

3. With news.php the active document, click the plus button at the top left of the Server Behaviors panel, and select Recordset.
4. When the Recordset dialog box opens, click the Advanced button on the right to enter Advanced mode (see Figure 9).
5. Enter getArchives in the Name text box.
6. Expand the Tables tree menu in the "Database items" area at the bottom of the dialog box, and then expand news. This displays the names of the columns in the news table.

   Select updated, and click the SELECT button twice.

   With updated still selected, click the ORDER BY button.

   After 3 hours, I still don't have a clue. Can someone help me?