mysql

[gntombel]

1.
I wish to transfer a database which is in xcel or Xcess format to mysql but the only idea I know of is when using the Load command and the Infile command with .txt file. Is it possiblevthat I can do this with these types of databases?

2.
I'm new to mysql and I want to add images into a database(mysql) which are of different categories. At the end of the day I want to link to a drop-down list each category show all images available in that category. When the user selects say image1, image1.jpg will be displayed. How can I go about doing this?

I have mySql and PHP as a starting point.

[motorwatchercounter]

You need to make sure that you set up the table names correctly. SQL is great but if you mess up it takes ages to recover. So step one is to get programmes that allow you to read the database and write to it so you can see what you are doing. Try http://www.puszkin.polbox.pl/. Unfortunatly it is written in Polish. There are English translations about (PM me if you need it in English). One you have the database you need to call the item you want. This is a different calling issue.

For something such as 1 file = 1 image you can use a CGI script (assuming you have CGI. This will run off a text file and allow images and URL's. Try csvsearch www.EZscripting.co.uk/csvsearch/ It's free, and easy to manage.

[gntombel]

I did visit the site but man......... that's bad news to me I don't understand a thing. I tried to translate the page but it didn't work out please help.

[motorwatchercounter]

I have PM'ed the instructions in English to you. If anyone else wants these let me know and I will put them on my server and provide a link for a couple of weeks for downloads.

:lol:

[Nomad]

why not just use phpmyadmin? best sql editor there is --- and free...