AUTO_INCREMENT FIELD

2001-06-20 Thread Alessandro Coppelli
Hi to all. I have this simple table create table tbl ( sid int not null auto_increment , filed1 LONGTEXT, field2 LONGTEXT, primary key (sid) ) When I insert one item ( insert into tbl values (filed1,filed2) ) I obtain error . Why ? Must I insert the sid ? If yes

QUERY IN C LANGUAGE

2001-06-15 Thread Alessandro Coppelli
Hi to all. I have this simple function : int process_query (MYSQL *conn, char *query){ if (mysql_query (conn, query) != 0) return(0); return(1); } and in the main : errore = process_query (conn, INSERT INTO PubblicheAmministrazioni

FROM C to MYSQL

2001-06-06 Thread Alessandro Coppelli
Hi to all. I would write a C programm for write a lot of variables in MySQL database. There are examples ? I try to write a cgi with Boutell library and then write the form variable in a database Alessandro - Before posting,