Here's an example from the top 3 rows of my text file (I separated the lines more to make it easier to distinguish new lines):
Code: Select all
Addino;;Sam;1996;New York;NY;United States;Freelance;;845-359-1789;staddino@aol.com;;;;;20010901
Albury;;Thomas W.;1991;;;;Assistant Editor;Sony Music Studios;212-724-8915;gotakeahike@hotmail.com;;;;;20011001
Amari;;Vince;1984;Montreal;PQ;Canada;Colorist;Covitec;;vam@bigfoot.com;;;;;
In this example, the sorted list would begin with "Albury" on top, followed by "Amari", and so on.... with "Addino" at the very bottom. Thinking that this may have been caused by not terminating the end of each line, I added a "#" to the end of every single line and tried again, telling phpMyAdmin that lines terminated with "#" (without the quotes). I still ended up with the same results. How do I get all this data into my table but without a space before the first item in every row (except the first row)?

Please help. Thank you.