P
PHP2
how add/update/delete data in MySQL database here?
CREATE TABLE IF NOT EXISTS example
(
item VARCHAR(255) NULL,
category VARCHAR(255) NULL,
picture LONGBLOB NULL,
model VARCHAR(255) NULL,
serial_number VARCHAR(255) NULL,
information TEXT NULL,
date_purchased DATE NULL,
depreciation DOUBLE NULL,
assigned_display DOUBLE NULL,
depreciation_life DOUBLE NULL,
remaining_life DOUBLE NULL,
cost DOUBLE NULL,
book_value DOUBLE NULL
) TYPE=MyISAM;
any help?
CREATE TABLE IF NOT EXISTS example
(
item VARCHAR(255) NULL,
category VARCHAR(255) NULL,
picture LONGBLOB NULL,
model VARCHAR(255) NULL,
serial_number VARCHAR(255) NULL,
information TEXT NULL,
date_purchased DATE NULL,
depreciation DOUBLE NULL,
assigned_display DOUBLE NULL,
depreciation_life DOUBLE NULL,
remaining_life DOUBLE NULL,
cost DOUBLE NULL,
book_value DOUBLE NULL
) TYPE=MyISAM;
any help?