
August 19th, 2002, 04:03 PM
|
|
|
|
Join Date: Apr 2007
Posts: 13
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Problem uploading database using phpMyAdmin
Been attempting to upload a database into MYSQL using the phpMyAdmin on my server. The database is converted from an Excel spreadsheet. One version of the conversion terminating the fields with a semicolon. The other is with comma. Since some of the fields have a comma in them, the comma delimitation obviously causes problems with the field order. The problem is when I use the semicolon, when browsing the table data in phpMyAdmin, it shows only the ID with all other fields blank. I can have a php page print out all the fields and they show. But if I do a "select * from table where filed='selected'" it shows a blank page. The method that should work best is using the semicolon termination, but the data doesn't show up in the browse or teh "select from". What do you think?
Note: the conversion process is multistep from Excel- cvs file- using a few search and replace in note pad to achieve ":" or ""," field termination.
|