Automating categories into tables

[jackson992]

Hi all:

Currently I have my tables named after the category of the stuff it contains such as automotive. I then add the info to the database one category at a time via a tab delimited text file. This is very time consuming however and I wondered if anyone knew of a way to automate it so that I can just load a tab delimited text file and it creates the tables for each category based on the category field.

[visualAd]

You can use a MYSql query to rip data from a text file. But as you have made a table for each category, you are shooting yourself in the foot. You could always write a PHP script which makes the additions for you, provided the data is consistent, however, it would be of much greater benefit to you if you were to create on table which has a field relating to the category, rather than a table for each.