Pls help me to understand the premise of SQL )(briefly)

[webmaniac]

I am in the process of trying to add a member registration page to my website...in the process of researching it I came across what looks like a neat program called XOOPS...in order to use the program my understanding was that MySQL is require on my web hosts' server and then I am to create an instance of a database with a user name and pw so that the installation process will read and write for the database.

Here is where I am getting confused. From what I understand, the web host server has MySql running on the server. What I don't understand is how do I create a database? Do I download a local copy of MySql and create an instance of a db and then upload the db into my root directory for my website? Or that a simplication...

All I really want to do is create a member registration page that would allow members to see restricted data. I have visual studio but it seems as though I would practically have to recreate my site in visual studio rather than just add to it.....

Any clarificatoin that anyone could provide me or any information you could direct me to read I would be grateful.

Confused in cyberland

[tabzter]

sounds like you got yourself into a pickle there.
Unfortunately MySQL isnt just a quick simple 1,2,3 setup and go kind of thing. You must read the associated documentation to get it installed. MySQL will not interact with the web on its own you will need a webserver and server-side language to interface with.

If you want a quick fix and you already own a domain which uses the Apache webserver, 1 solution might be to use a restrictive .htaccess directive file. (there maybe similar solutions for other servers if your host dont use apache).

[webmaniac]

thank you! i will definately look into that. I think for purposes of the demonstration i will jsut make it appear to be functional. thanks a great deal!

[NogDog]

If your web host is providing MySQL, there's a good chance that there is some graphical interface available via your host's website control panel. That interface will likely provide tools both for database creation and database user/password creation. I would therefore suggest browsing through your control panel (and any help screens), or contact your web host customer service if you can't find what you need.