Re: Adding to multiplied values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On Fri, 19 May 2006, Volkan YAZICI wrote:

On May 18 10:45, Reed Loefgren wrote:
I've been hacking away on a little time billing database and I've been
having difficulty adding to a calculated amount.

Can we see the exact PHP code stands for the execution of related query?


Regards.



Sure, and thanks. This query works, but I fail at tying in $totalExpenses to create a $grandTotal. (pine is gonna butcher this...);

$query = "INSERT INTO invoices2 (idate, iperiod, inum, ijobcode, iaccount, icomp, itime, isub, create_time) VALUES('" . $invoiceDate . "', '" . $billingPeriod . "', '" . $invoiceNumber . "', '" . $jobCode . "', '" . $accountNumber . "', '" . $billingRate . "', '" . $totalHours . "', '" . $billingRate * $totalHours . "', 'now()')";


r


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux