A Database Error Occurred Error Number: 1064

[eluser]veledrom[/eluser]
Hi,

I deliberately put faulty query in my model to see what happens. Obviously I get this error message:

Code:

A Database Error Occurred
Error Number: 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 '('4.50', '5', 22.5, '3', '2', 12, 11' at line 3

INSERT INTO item (unitprice, quantity, total, pk_colour_id, pk_product_id, pk_customer_id, pk_order_id) VALUES ('1.67', '10', 16.7, '1', '1', 12, 11) ('4.50', '5', 22.5, '3', '2', 12, 11

Filename: D:\system\database\DB_driver.php

Line Number: 330

It is not good showing it to users so I added error_reporting(0); to my model but, the error message still remains on the screen.

How can I solve this problem?

Thanks

[eluser]wiredesignz[/eluser]
application/config/database.php

Code:

$db['default']['db_debug'] = FALSE;

[eluser]veledrom[/eluser]
Excellent, thanks