homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

PHP import only few columns from csv

5+ Year Member

Msg#: 4073736 posted 7:31 pm on Feb 3, 2010 (gmt 0)

Hello guys,

I have a table with around 15 rows, one of them is Phone number field. SO when I export the database using Phpmyadmin and open that csv file in excel, the phone number format is lost, excel thinks that it is scientific number and does exponential functions. (eg. phone number 260000000, it changes this to 2.6E7), SO after all the hard work im thinking only to import few columns except the phone number. so is there any way that I can import only 2-3 columns which changes as per my needs into the database.



Msg#: 4073736 posted 7:46 am on Feb 8, 2010 (gmt 0)

is there any way to format the phone number, maybe throw a dash or two in there before importing, I truly despise that excel does this!

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved