If your recordset is working ok, but you want to limit the number of rows returned, you need to add the LIMIT keyword to the SELECT statement
SELECT artworks.id, artists.name
FROM artworks INNER JOIN artists ON artworks.artist_id=artists.id
LIMIT 1
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.