create a session variable to hold today's date in the yyyymmdd format:
<?php
$_SESSION['today'] = "".date('Y')."".date('m')."".date('d')."";
?>
you can create the recordset in simple view using dreamweaver, set the filtering section to filer the type_ad field equal to session variable today.
filtering:
'type_ad' '='
'Session variable' 'today'