I have successfully learned to Insert data to a website using the Insert Record command under behaviors in DMX. I have also added a repeat data function but now I would like to add a sorting function so the last posting is at the top of the list. I have poked around mySQL Manager and Dreamweaver in the Help files but I have not found anything. Is this done in mySQL or in Dreamweaver? I am assuming it's done in Dreamweaver because I have changed the order of the data in mySQL and the next inserted data is still put at the bottom. What do I need to do?

Use the Order By statement in your sql.

If you have a date or a sequential id you can sort by that.

When you add a recordset click on advanced and add something like the following:

Select *
from yourtable
Order By Date ASC

ASC will sort ascending
DESC will sort descending.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Works perfectly, thank you so much.