[SOLVED] Inserting multiple rows within one query...

[forumnz]

Why does this not work? It just doesn't insert anything..

 

mysql_query("INSERT INTO chart_of_accs (hash_key, acc_hash, type, code, name, description, tax, show_exp_claims, sys_locked) 
VALUES ('$demo_hash', '" . md5(rand() . rand() . rand()) . "', 'r_r', '200', 'Sales', 'Income', 'gst_n', '0', '0'),
('$demo_hash', '" . md5(rand() . rand() . rand()) . "', 'e_o', '400', 'Advertising', 'Advertising', 'gst_n', '0', '0')");

 

Thanks

Sam

[premiso]

Probably due to type being in art of the columns. Add this to see the error:

 

mysql_query("INSERT INTO chart_of_accs (`hash_key`, `acc_hash`, `type`, `code`, `name`, `description`, `tax`, `show_exp_claims`, `sys_locked`)
VALUES ('$demo_hash', '" . md5(rand() . rand() . rand()) . "', 'r_r', '200', 'Sales', 'Income', 'gst_n', '0', '0'),
('$demo_hash', '" . md5(rand() . rand() . rand()) . "', 'e_o', '400', 'Advertising', 'Advertising', 'gst_n', '0', '0')") or die(mysql_error());

 

Give that a try and see what it returns.

 

[forumnz]

It just comes up with:

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 'assets', 'gst_n', '0', '0'), ('4dee86e7c8696a5e41d71ef9a31c3682', '68317fcd9aec' at line 9

 

What does this mean?

[premiso]

That you are showing us the wrong code. I do not see assets in the code you provided anywhere. , I see "Income" where assets should be.

[forumnz]

There is no 'assets' being inserted anywhere in the code.. thats what I don't get..?

[forumnz]

Thanks - got it!