Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Populate Recordset only if current DATE and TIME matches

Populate Recordset only if current DATE and TIME matches

Thread began 10/30/2009 7:01 am by info305726 | Last modified 11/02/2009 4:32 pm by info305726 | 3989 views | 17 replies

11/01/2009 2:59 aminfo305726

Hi Brian,

So could I put an record update within the conditional PHP code as you suggested to insert a value of "1" into the database column alertShown (which will be null the first time it is queried)?

<?php

if ($row_tasks['alertshow'] < 1) { ?>

code to UPDATE column "tasks.alertShown" to "1" for every record retrieved by the recordset

<?php } ?>

Do I need to use Data Assist to achive this? or is their some custom code that needs to be written to do this? and if so could you point me in the right direction?

Thanks again for all your help.

Lee

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.