Can I get help with this ..

[fierce]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'num, ticket, cash ) VALUES
( 0 , 0 , 100000000), ( 0 , 1 , 100000' at line 1
http://img61.imageshack.us/my.php?image=mysqlkc0.jpg
thx in advance
fierce

[marshian]

What are you trying to do?
I'm guessing you should add "INSERT INTO `tablename`" at the start of the database, but I'm not sure, as this 'query' doesn't really mention what he tries to achieve.

[scopey]

Yeah, the query is missing the whole first line or something. Why are you using the SQL console anyway? phpMyAdmin provides a really nice GUI to your database. Use that to enter values.

But anyway, you need the INSERT INTO `tablename` on the first line infront of ('num', 'ticket', 'cash')

[ryanlwh]

Well take a closer look at the attachment. He's using phpMyAdmin .

And as other pointed out, you're just missing INSERT INTO tablename

[scopey]

Yes, but he's using the SQL query part of phpMyAdmin... There's a nicer, easier way to enter data into a table.

[fierce]

.. There's a nicer, easier way to enter data into a table.

What's that ?

[sunils]

There may be more that one reason for this error coming up...
(1). since you have specified the column names in the query, check whether you have not missed out any column which is set to not null.
(2).The second reason could be that the datatype of the column and the datatype of the data does not match. So you need to convert it to the respective format before executing the query..

since i could not access the image (because of the restriction on our network) can you post the entire query that you are using.

[fierce]

There may be more that one reason for this error coming up...
(1). since you have specified the column names in the query, check whether you have not missed out any column which is set to not null.
(2).The second reason could be that the datatype of the column and the datatype of the data does not match. So you need to convert it to the respective format before executing the query..

since i could not access the image (because of the restriction on our network) can you post the entire query that you are using.

i fixed the problem with that..but i can't insert this
INSERT INTO eras
( name , peasants , food , mana , infantry , cavalry , siege , naval , wizards , homes , mines , academies , barracks , mage towers , farms , towers , o_infantry, d_infantry, o_cavalry, d_cavalry, o_siege, d_siege, o_naval, d_naval) VALUES
('Dark' ,'Villagers' ,'Grains' ,'Mana' ,'Pikemen' ,'Cavalry' ,'Archers' ,'Galleons' ,'Wizards' ,'Huts' ,'Mines' ,'Academies','Keeps' ,'Mage Towers' ,'Farms' ,'Towers' , 1 , 2 , 3 , 2 , 7 , 5 , 7 , 6 ),
('Mystical','Peasants','Grains','Mana' ,'Swordsmen','Heavy Cavalry' ,'Bowmen' ,'Battleships' ,'Sorcerers' ,'Houses','Gold Mines','Military Academies','Keeps','Mage Towers' ,'Plantations' ,'Sentry Towers' , 2 , 1 , 2 , 6 , 5 , 3 , 6 , 8 ),
('Imperial' ,'Citizens','Grains','Mana','Long Swordsmen' ,'Cataphract','Crossbowmen','Juggernauts','Spellca sters ','Houses','Gold Mines','Imperial Academies','Keeps','Mage Towers','Imperial Plantations','Guard Towers', 1 , 2 , 5 , 2 , 6 , 3 , 7 , 7 );

http://img78.imageshack.us/img78/1299/mysql1sw5.jpg

[woiwky]

The problem is the 'mage towers' part. You can't have spaces in field names. Perhaps you meant mage_towers instead?

[scopey]

What's that ?

Hit the insert tab at the top of the page