help for stocking program

[peacengell]

hi i need to know how can we can make addition in one table in mysql from php
let say i have a guest book
and i have a qty colum
and i want it to update the quantity by one each time one guest add in how can i do that with php/mysql
any help please waiting for so long to get this working
please newbiee
help

[carrotderek]

You can set a column to auto-incremement in MySQL.

for instance

CREATE TABLE Guestbook
(
 Qty SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
 Name VARCHAR(40) NOT NULL,
 Body VARCHAR(40) NOT NULL,
 PRIMARY KEY (Qty)
);