Need help with updating mysql

[Anon]

Question, using php to update contacts in mysql, when i update a field such as address it only updates everything before a space.

For example:

If the address is blank and i say 123456 W. Street and click update, it only enters 123456.

So how can I make it add all of it?

Thanks in advance!

John

[steved]

It's hard to be certain without seeing your update statement, but I suspect you just need to put quotes around your address data.

Something like:

$sql = "Update myTable Set myAddress = '1234 Main' Where ID = $ID";

[Anon]

I would agreed with the previous post... although it could be that the field is at int field rather than a char() or varchar().

Neil

[Anon]

Yep stupid me. Figured it out like right after I posted this. My quotes were wrong. Heh. Thanks for the fast response!