[PHP-DB] Help on query report...

2006-11-16 Thread Suprie
dear all, i have this table id | contract No | site id | handover date |status| finishing date | contract value|actual value 1 | T0001 | LOS01 | 12-Apr-06| Done | 11-Apr-06 | 12,000 | 12,000 2 | T0002 | LOS02 | 12-Apr-06| Done | 11 Apr-06 | 11

[PHP-DB] help in database design

2007-03-28 Thread Suprie
hi all, i need help in design a database, our office is hospital equipment supplier, we had a list of items, each items had it's own configuration, and each item could consist of several item. we also had contract that have a lot of site, sometimes equipmend that have been ordered different from

[PHP-DB] Database Object

2007-09-24 Thread Suprie
dear all, straight to the point... i have this class class Contract { private $id; private $date; private $c_number; -- setter and getter -- } class ContractCME extends Contract { private $tower_height; private $shelter; -- setter and getter -- } class ContractCMD