Re: Adding to multiplied values
От | Reed Loefgren |
---|---|
Тема | Re: Adding to multiplied values |
Дата | |
Msg-id | 20060519065138.K92929@auden.jmla.com обсуждение исходный текст |
Ответ на | Re: Adding to multiplied values (Volkan YAZICI <yazicivo@ttnet.net.tr>) |
Ответы |
Re: Adding to multiplied values
|
Список | pgsql-php |
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
В списке pgsql-php по дате отправления: