Importing csv table into database – sort order changes?

  • harvest101

    (@harvest101)


    13 years, 6 months ago

    Hi,
    I am importing a table into my database via phpMyAdmin, the table populates a couple of dropdowns on my site.

    For some reason even though the table is in the correct order in csv/excel format, once it is imported the order changes, so the order of the list on the dropdowns on my website is wrong (it should be alphabetical).

    I can’t see any logic in the way the table is re-sorting itself on import, I import it alphabetically descending, once imported the top 5 or so are sorted ascending (correct), and the next ones are in a random order. How can I make it import the table in a specific order?

Viewing 1 replies (of 1 total)
  • fonglh

    (@fonglh)

    13 years, 6 months ago

    This isn’t a WordPress question.

    Anyway you can always use SQL to order the list when you make the query.

Viewing 1 replies (of 1 total)

The topic ‘Importing csv table into database – sort order changes?’ is closed to new replies.