ps-what's the "id" field for?

I'd put an auto-incrementing counter there - gives you a guaranteed unique key/id for each row (though a properly formed timestamp could serve the same purpose if you guarantee never to try multiple additions within the resolution of the timestamp format).
If you use american format for date and a text field for holding it (instead of a proper date/time field), a sequential id would also be good for sorting in actual entry order...


Not having played with MySQL myself, I'd imagine adding a row could be done in the same way as most any other SQL database:

INSERT INTO tablename (column1, column2, column3, etc) VALUES (value1, value2, value3, etc);

You need to list and give values for (at least) all required columns except the autogenerated ones (like autoincrementing counter)

/Michael