Basic MySQL question

[mato]

I have a list of raw data in several CSV files, just long lists of different codes.

I'm trying to create a webpage which is just a search function, whereby a user types in a number and, depending on which table the code is in, it will redirect them to a webpage accordingly.

Can I do this with MySQL/PHP?

For example,

 

user types in "056747392" into the search box on the webpage.

Multiple tables are searched for this exact number.

If the number is found in "table 3", the user would be directed to table3.html, or the page would display the content allied to table 3.

 

Is this difficult?

(sorry if this makes no sense)

Edited May 13, 2013 by mato

[Jessica]

Yes, it's possible.

Is it difficult? Honestly, if you have to ask if it's possible, yes, you will probably find it difficult.

 

Why do you have multiple tables with the same type of data? Why do you have multiple pages for the same type of data?

[mato]

So at the moment it's like I have for example two CSV files, one for FOOD, one for DRINK.

Each file contains one column with a list of product codes.

I can easily merge the tables together to create one table and create a second column, specifying if that product code is FOOD or DRINK.

 

So if the user searches the product code, it would search the one table, and if there's a match, it would perform "x" action, dependent on what the product is FOOD or DRINK.

Edited May 13, 2013 by mato

[Jessica]

Google "data normalization"