Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Multiple update records does not work. Please help

Multiple update records does not work. Please help

Thread began 2/24/2011 1:48 pm by danny405167 | Last modified 2/25/2011 12:29 pm by danny405167 | 2167 views | 4 replies

2/25/2011 12:29 pmJason ByrnesWebAssist

in this case, I would not store the total in the database at all, i would either calculate the total in the recordsets i create:
SELECT *, FORMAT(price * qty,2) AS total FROM tablename

or i would calcualte it in the php:
<?php echo($row_Recordset1['price'] * $row_Recordset1['qty']); ?>

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.