Hi Mike :)
I assume you have Dreamweaver.
I assume you have a MySQL server and a database with a table created with some fields.
I assume that you have created a MySQL connection in Dreamweaver.
You mentioned creating a Recordset.
Just a simple query would be
SELECT * FROM tablename_goes_here
That will work.
Be sure and save your page. Can you show a screenshot of what you're seeing?