homepage Welcome to WebmasterWorld Guest from 107.22.70.215
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Accredited PayPal World Seller

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
friendof2005




msg:4073738
 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.

 

jasonspalace




msg:4076169
 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.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved