(20:42:31) comexk: CREATE TABLE orders(orderid int primary key not null auto_increment, item_id int, item_quantity int);
(20:43:00) Jeremie: (ok keep typing ill brb dinner)
(20:43:17) comexk: CREATE TABLE items(item_id int primary key not null auto_increment, item_name varchar(255), item_description text, (maybe) item_price int unsigned, stock int unsigned);
(20:43:37) comexk: so
(20:43:40) comexk: after you do that
(20:44:02) comexk: in some php scripty ou can SELECT * FROM orders and then have a link to a page for each order in which you simply DELETE FROM orders with the orderid and decrement the stock
(20:44:02) comexk: i.e.
(20:44:07) comexk: DELETE FROM orders where orderid = blahblahblah;
(20:44:22) comexk: UPDATE items SET stock = stock - 3 WHERE item_id = blahblahblah;