bad SQL Error

Hy

Can everyone help by the follow error ...

Code:

---

SQL Error

Incorrect integer value: '' for column 'metal_perhour' at row 1
INSERT INTO game_planets SET `name` = 'Estustil', `id_owner` = '5', `galaxy` = '1', `system` = '1', `planet` = '10', `last_update` = '1235035227', `planet_type` = '1', `image` = 'wasserplanet03', `diameter` = '12750', `field_max` = '163', `temp_min` = '-9', `temp_max` = '31', `metal` = '500', `metal_perhour` = '', `metal_max` = '1000000', `crystal` = '500', `crystal_perhour` = '', `crystal_max` = '1000000', `deuterium` = '500', `deuterium_perhour` = '', `deuterium_max` = '1000000';

---

This error occurs when someone has registered :*:

By assigning the parameter '', your basically telling MySQL that it's a string although it's not. It's an integer therefor it's real not a string.

Input something between the quotes `metal_perhour` = '' or if the error still persist try removing the quotes and put a real integer instead.