MySQL users! Help!

Developers!
I need some serious help. I'm trying to make a web based software that connects to MySQL database. Problem is, I do not know anything (I mean none) about MySQL or MS SQL, so the help pages at mysql website does not make any sense to me... I'm pretty good with ms access database(mdb), and know that sql works basically in same sense.... right?
However, I don't know how to install, create table, linke the tables, make queries, and make web-based form to link to the table...
So far, I have downloaded MySQL install file. That's it. Can anyone help with this, or actually help me with this software project? maybe with little bit of side money???
Anyway, Help!

 

Yikes!

Think you may have possibly stepped in it here!

Reason being that to create a database connected website, you need to know a web scripting language (typically PHP) to 'parse' the SQL commands.

MS Access works... SIMILARLY.... you can query the database using SQL (Structured Query Language), but that's about where the similarities end.

Your first step is to get a webserver running a scripting language.

www.php.net to download and reference
www.w3schools.com for tutorials.

 

Mada,
Thank you for your prompt reply! I do not know PHP scripts but I did install it on the web server that will run this. why, you ask? I am running php based form(feedback form) on the server. and also, read about php some where and thought I would need it later, so I installed it anyway.(I did alot of research before this posting, believe it or not... hehe...)
The php feedback form i'm running now is simple free script form that I got from a site.
so, I think that's taken care of. My web server is currently up, and i'm running simple intranet on it.. it also has some java scripts pages and works great. so.... what's next? Do I have to install MySQL on the same server (I shouldn't have to)?

 

No, you don't have to install MySQL on the same server, but it would eliminate the overhead introduced by querying the database across a network.

Since you know that your PHP installation is working on your webserver, we just have to configure it to expose the MySQL functions. (Normally disabled by default to save memory)

We want to go into your PHP.INI file and uncomment the 'LoadModule php_mysql.dll' directive.

See this link for a tutorial on PHP MySQL commands.

There is a tool that you might be interested in. It's called phpMyAdmin and it is a webpage you can setup on your php-enabled webserver. It provides an administrative GUI for your MySQL database. Selecting radio buttons and drop down menus on its pages generate (and executes) the MySQL commands for you.

 

This may sound silly, but there's some truth here:

Since you say that you're familiar with MS Access, you might use that as a learning tool, as well!

When you design queries, Access generates the SQL code as well. You can view them by right-clicking your query, and selecting 'SQL View'

Ontop of that, you could run test queries in a dummy database, although there's probably more value in doing this in your MySQL server. Once you get a few commands, you'll know how to easily create a pilot DB.