in dreamweaver there is a show region behavior for this.
select the parts of the page that should show if a record is returned, the go to window -> Server behaviors. in the server behaviors panel click the plus button and select Show Region.
set it to show if the products recordset is NOT empty.
no create the no records error message, select that and add a second show region behavior, this select to show it if the products recordset IS empty.