Jump to content

problems with storing data


eranwein

Recommended Posts

i have a tsble field which is defined as varchar(11) for storing mobile phone number.
the values should be in this format: 999-999999.

when i run an UPDATE query, it stores it with different value and without the "-".

but when i write it directly to the database with mysql-front there is no problem.

so, what should i do?

let me just say that i know about the option of seperating the two values into two different fields, but i would prefer it to be done as explained.


Link to comment
https://forums.phpfreaks.com/topic/4940-problems-with-storing-data/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.