update setting all fields to zero

[eluser]Samus[/eluser]
[quote author="mflammia" date="1334220512"]Thanks for repling

The $person array looks like the below for this particular update:

Code:

Array
(
    [first_name] => Joe
    [second_name] => Bloggs
    [dob] => 1972-08-11
    [phone] =>
    [email] =>
)

Although if I set phone and email to 0, the same problem exits?[/quote]
Check their data types.

For example if your first_name data type is set to "int" (integer) it will only expect an integer any other string inserted will be defaulted to 0.

If this is the case just change their data type to varchar and specify a length.

EDIT: nvm, i see you have appropriate data types