WHC_list_dbtry.html

WHC Sites Inventory

WHC - the2nd

adb

28:/home/clgpke02/public_html/ztry_mydbs/mysql_whc_the2nd.php
Array
(
    [hostname] => localhost
    [dbname] => clgpke02_the2nd
    [username] => clgpke02_the2nd
    [password] => T#esec0nd
    [strSQL] => select * from coi2_products
)

dbLink

38:/home/clgpke02/public_html/ztry_mydbs/mysql_whc_the2nd.php
Resource id #3

strErr

39:/home/clgpke02/public_html/ztry_mydbs/mysql_whc_the2nd.php

mysql_connect: OK

strErr

51:/home/clgpke02/public_html/ztry_mydbs/mysql_whc_the2nd.php

mysql_select_db: OK

strSQL

60:/home/clgpke02/public_html/ztry_mydbs/mysql_whc_the2nd.php
select * from coi2_products

rcds

83:/home/clgpke02/public_html/ztry_mydbs/mysql_whc_the2nd.php
Array
(
    [0] => Array
        (
            [0] => 1
            [1] => SQL: select * from coi2_products
            [2] => 7
        )

    [1] => Array
        (
            [prod_id] => 1
            [prod_status] => 1
            [prod_name] => Web Service (month)
            [prod_desc] => Basic web support service (montly)
            [prod_unit_cost] => 20.00
            [prod_client_scope] => -1
            [prod_apply_tax_01] => 1
            [prod_apply_tax_02] => 0
            [prod_calc_tax_02_pb] => 0
            [prod_dom_type] => 1
            [prod_allow_domains] => 0
            [prod_allow_subdomains] => 0
            [prod_allow_disk_space_mb] => 0
            [prod_allow_traffic_mb] => 0
            [prod_allow_mailboxes] => 0
            [prod_allow_databases] => 0
            [prod_cg_01] => 0
            [prod_cg_02] => 0
            [prod_cg_03] => 0
            [prod_cg_04] => 0
            [prod_cg_05] => 0
            [prod_cg_06] => 0
            [prod_cg_07] => 0
            [prod_cg_08] => 0
        )

    [2] => Array
        (
            [prod_id] => 3
            [prod_status] => 1
            [prod_name] => Wed Developmet (reg)
            [prod_desc] => Web development (regular, per hour)
            [prod_unit_cost] => 40.00
            [prod_client_scope] => -1
            [prod_apply_tax_01] => 1
            [prod_apply_tax_02] => 0
            [prod_calc_tax_02_pb] => 0
            [prod_dom_type] => 0
            [prod_allow_domains] => 0
            [prod_allow_subdomains] => 0
            [prod_allow_disk_space_mb] => 0
            [prod_allow_traffic_mb] => 0
            [prod_allow_mailboxes] => 0
            [prod_allow_databases] => 0
            [prod_cg_01] => 0
            [prod_cg_02] => 0
            [prod_cg_03] => 0
            [prod_cg_04] => 0
            [prod_cg_05] => 0
            [prod_cg_06] => 0
            [prod_cg_07] => 0
            [prod_cg_08] => 0
        )

    [3] => Array
        (
            [prod_id] => 4
            [prod_status] => 1
            [prod_name] => Basic web support se
            [prod_desc] => Web support service Special (Quaterly)
            [prod_unit_cost] => 42.71
            [prod_client_scope] => 0
            [prod_apply_tax_01] => 1
            [prod_apply_tax_02] => 0
            [prod_calc_tax_02_pb] => 0
            [prod_dom_type] => 0
            [prod_allow_domains] => 0
            [prod_allow_subdomains] => 0
            [prod_allow_disk_space_mb] => 0
            [prod_allow_traffic_mb] => 0
            [prod_allow_mailboxes] => 0
            [prod_allow_databases] => 0
            [prod_cg_01] => 0
            [prod_cg_02] => 0
            [prod_cg_03] => 0
            [prod_cg_04] => 0
            [prod_cg_05] => 0
            [prod_cg_06] => 0
            [prod_cg_07] => 0
            [prod_cg_08] => 0
        )

    [4] => Array
        (
            [prod_id] => 5
            [prod_status] => 0
            [prod_name] => Web Quaterly
            [prod_desc] => Web support service  (Quaterly)
            [prod_unit_cost] => 60.00
            [prod_client_scope] => 0
            [prod_apply_tax_01] => 1
            [prod_apply_tax_02] => 0
            [prod_calc_tax_02_pb] => 0
            [prod_dom_type] => 0
            [prod_allow_domains] => 0
            [prod_allow_subdomains] => 0
            [prod_allow_disk_space_mb] => 0
            [prod_allow_traffic_mb] => 0
            [prod_allow_mailboxes] => 0
            [prod_allow_databases] => 0
            [prod_cg_01] => 0
            [prod_cg_02] => 0
            [prod_cg_03] => 0
            [prod_cg_04] => 0
            [prod_cg_05] => 0
            [prod_cg_06] => 0
            [prod_cg_07] => 0
            [prod_cg_08] => 0
        )

    [5] => Array
        (
            [prod_id] => 6
            [prod_status] => 1
            [prod_name] => Allstream
            [prod_desc] => Allstream Telecom Services
            [prod_unit_cost] => 0.00
            [prod_client_scope] => 0
            [prod_apply_tax_01] => 1
            [prod_apply_tax_02] => 0
            [prod_calc_tax_02_pb] => 0
            [prod_dom_type] => 0
            [prod_allow_domains] => 0
            [prod_allow_subdomains] => 0
            [prod_allow_disk_space_mb] => 0
            [prod_allow_traffic_mb] => 0
            [prod_allow_mailboxes] => 0
            [prod_allow_databases] => 0
            [prod_cg_01] => 0
            [prod_cg_02] => 0
            [prod_cg_03] => 0
            [prod_cg_04] => 0
            [prod_cg_05] => 0
            [prod_cg_06] => 0
            [prod_cg_07] => 0
            [prod_cg_08] => 0
        )

    [6] => Array
        (
            [prod_id] => 7
            [prod_status] => 1
            [prod_name] => Electricity
            [prod_desc] => Enersourse Electricity
            [prod_unit_cost] => 0.00
            [prod_client_scope] => 0
            [prod_apply_tax_01] => 1
            [prod_apply_tax_02] => 0
            [prod_calc_tax_02_pb] => 0
            [prod_dom_type] => 0
            [prod_allow_domains] => 0
            [prod_allow_subdomains] => 0
            [prod_allow_disk_space_mb] => 0
            [prod_allow_traffic_mb] => 0
            [prod_allow_mailboxes] => 0
            [prod_allow_databases] => 0
            [prod_cg_01] => 0
            [prod_cg_02] => 0
            [prod_cg_03] => 0
            [prod_cg_04] => 0
            [prod_cg_05] => 0
            [prod_cg_06] => 0
            [prod_cg_07] => 0
            [prod_cg_08] => 0
        )

    [7] => Array
        (
            [prod_id] => 8
            [prod_status] => 1
            [prod_name] => Natural Gas
            [prod_desc] => Enbridge Natural Gas
            [prod_unit_cost] => 0.00
            [prod_client_scope] => 0
            [prod_apply_tax_01] => 1
            [prod_apply_tax_02] => 0
            [prod_calc_tax_02_pb] => 0
            [prod_dom_type] => 0
            [prod_allow_domains] => 0
            [prod_allow_subdomains] => 0
            [prod_allow_disk_space_mb] => 0
            [prod_allow_traffic_mb] => 0
            [prod_allow_mailboxes] => 0
            [prod_allow_databases] => 0
            [prod_cg_01] => 0
            [prod_cg_02] => 0
            [prod_cg_03] => 0
            [prod_cg_04] => 0
            [prod_cg_05] => 0
            [prod_cg_06] => 0
            [prod_cg_07] => 0
            [prod_cg_08] => 0
        )

)