very basic help on query and db issue

Hi people, I apologize that this question might not be quite relevant to the list purpose and it is more to do with mysql though. But I thought it is quite basic problem that no so complex db issue so I just give it a go. Anyway, get into my problem. ****************************************************************** I have a table as shown below and when I tried to run the query ( direct at Mysql db, not from a php page) : INSERT INTO Hoteldetail VALUES ('test', 'thai', 'thai', '12', '11', '124', '', 'firstname', 'LastName', 'RoomProvided', 'mail@mm.net'); I got an error said:"ERROR 1136: Column count doesn't match value count at row 1" +-----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------+----------------+ | HotelID | bigint(20) unsigned | | PRI | 0 | auto_increment | | HotelName | varchar(30) | YES | | NULL | | | HotelLocation | varchar(30) | YES | | NULL | | | HotelCountry | varchar(20) | YES | | NULL | | | HotelPostcode | varchar(10) | YES | | NULL | | | HotelTelephone | varchar(20) | YES | | NULL | | | Hotelfax | varchar(20) | YES | | NULL | | | HotelURL | varchar(30) | YES | | NULL | | | HotelContactFirstName | varchar(20) | YES | | NULL | | | HotelContactLastName | varchar(30) | YES | | NULL | | | HotelRoomProvided | int(10) | YES | | NULL | | | HotelEmail | varchar(70) | YES | | NULL | | +-----------------------+---------------------+------+-----+---------+----------------+ ************************************************** what have I done wrong at the table? cheers Jack jacky@activelifestyle.com "There is nothing more rewarding than reaching the goal you set for yourself"