ID: 12052 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Closed Bug Type: InterBase related Operating System: winme PHP Version: 4.0.6 New Comment:
The version of PHP that this bug was reported in is too old. Please try the php-4.2.0RC3 from http://www.php.net/~derick/ If you are still able to reproduce the bug, please change the PHP version on this bug report to the version you tested and change the status back to "Open". Previous Comments: ------------------------------------------------------------------------ [2001-07-11 10:04:31] [EMAIL PROTECTED] BUG id #12006 Dear Derick /* Table: LOTTERY, Owner: SYSDBA */ CREATE TABLE "LOTTERY" ( "INSTALL1" DATE NOT NULL, "RATE1" NUMERIC(9, 2), "INSTALL2" DATE, "RATE2" NUMERIC(9, 2), "TOTAL" COMPUTED BY (rate1 + rate2), CONSTRAINT "pkLOTTERY" PRIMARY KEY ("INSTALL1") ); The above is my table structure. the following is my php code that produce previous mentioned bug. ibase_timefmt("%d/%m/%Y", IBASE_DATE); $db = ibase_pconnect('c:/mydb.gdb', 'SYSDBA', 'masterkey'); $query = "select * from lot"; $result = ibase_query($db, $query ); $sum = 0; $rowcount = 0; print "<h1><center>Lottery</center></h2>"; print "<table border>"; print "<tr><th>DATE01</th><th>TOTAL1</th><th>DATE16</th><th>TOTAL2</th><th>TOTALSUM</th></tr>"; while( $row = ibase_fetch_row( $result )){ $s = sprintf( "<tr><td>$row[0]</td><td align = right>%s</td><td>$row[2]</td><td align = right>%s</td><td align = right>%s</td></tr>", number_format($row[1], 2),number_format($row[3], 2), number_format($row[4], 2)); print $s; $sum += $row[4]; $rowcount++; } ibase_free_result($result); ibase_commit(); ibase_close($db); sorry for any incoutesy I'm very novice for responding by this system. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=12052&edit=1
