Hi all,

I am a newbie so please forgive if this seems incredibly simple.

Ok, this is the situation. I have two excel sheets and a folder with images what I want to do is combine all the data. Both sheets have duplicating data i.e. names publishing dates and more. Currently a user uses one sheet to find out a corresponding book jacket. It happens that the ISBN is used to find the jacket pic. Both sheets hold ISBN info, and the images in a folder on their own are named with ISBN numbers … can you see where I’m going?

My goal is to create a database (Mysql) that if certain data is input to search against i.e. ISBN, or Author it will pull info and the cover pic. Does this make sense?
I know I have to run a query against ISBN or something and some how create a new table but where do I start?

Can anyone guide me on this quest to link pic with ISBN numbers...?

CHeers and a BIG Thanks in advance

just make a table like this:

CREATE TABLE info (Name CHAR(100) NOT NULL, ISBN CHAR(30) NOT NULL)

where info is the table name and Name and ISBN are the names of columns in the table.

then you can call the information like this:

SELECT Name FROM info WHERE ISBN='the ISBN #'

you'll have to open the image and display it with whatever script you are using to display the info.