Configure Database in Dreamweaver, (Spesific Result)

[sasacool66]

How do I show only a specific record and not all records or the last record. What if I want to show a specific record where sno=1 on one page and on another page value of a field where sno=2?E.G.If I have a Product Name and Price table in my DB, and I have multiple product pages where I want to show these product's prices, I want the prices to be fetched from the DB Table dynamically so that I can update these prices easily from the table.

[sasacool66]

So price displayed where prod name = prod1 on page prod1.html and price for prod name= prod2 on prod2.html and so on. How should I do that? Please help.

[ShadowAuraSite]

@sasacool66 well when you are creating recordset you can click on Advance button and you can enter custom SQL Query there

but remember you cant go back on simple mode mostly when you use more complex SQL Queries