what taype type to use?

Hello,

I am working on the database that will have 5+ tables.
These tables will be accessed for data entry, data modification, data searching and so on. Also these tables will be accessed by more than one users at a time.
The data is of very cruical nature.

I am wondering that what table type I shall be using for my database. I am using PHPMyAdmin. I have these choices:

MyISAM
HEAP (which is not for such database)
MEMORY
MERGE
MRG:MyISAM
InnoDB
INNOBASE

Thanks in advance


The second thing that bugs me is that: Is it possible if two users are entering/modifying data at the same time in the same table, they can mess up with the data? I am using SESSIONS that consists of username, IP and time in millisecond.

Stick with MyISAM unless you know what you're doing.

MySQL is designed to handle millions of queries per second. You will not have problems with two or three people updating the database at once.

Now, if you are both editing the same row in phpMyAdmin, you could easily overwrite each other's work, but that's not really a database issue.