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', '[EMAIL PROTECTED]');
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
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"
