insert phone number format

[New_Coder]

Hi,
I have any form for register member. my field phone number is 3 text input .
how to import into one row(col) mysql?? and how to show for edit .

Example : 123 456 7899 <- this is phone number
thanks

[JVassie]

Well, on the page you use to insert the data into a MySQL table, what code do you have already? What are the 'name' attributs of the 3 text input boxes for the phone number?

[dalecosp]

It's just simple text formatting ... I assume from the $POST array?

$ten_digit_number=$_POST['field1']."-".$_POST['field2']."-".$_POST['field3'];

Now, use $ten_digit_number in your SQL queries:

$query="insert into mytable values($ten_digit_number)";
$result=mysql_query($query);
if (!$result) {
  die("Database write failed!");
} else {
   echo "Number was added to database.";
}

Keep in mind this is slightly simplified, and not tested yet, but this is the basic idea.

Perhaps you need a good textbook? http://www.amazon.com/Beginning-Apache-MySQL-Development-Programmer/dp/0764579665

[New_Coder]

Yes, this is basic and worked ! but my problem this :
after register user can edit field ! now how to show this digit number to three text box.
123-456-7899 <- sql query ! now this query add to three text box for edit .

[bradgrafelman]

When you retrieve it, [man]explode/man the data into three separate quantities again and fill in the appropriate piece into the appropriate box.