Help Me With The Code, code

[Glorifindal]

I'm trying to create a game kind of like heroes of ardania. And I dont get how you would make a database to store heroes passwords and usernames could some one help please! the game

[Karmic]

What programming language are you using?

Basically, you'll want to start by choosing a database system (MS Access, mySQL, SQL Server, etc), and then reading any books about that system that you can get your hands on. Online tutorials are also good. After a month or so you should have mastered the basics.

[Glorifindal]

I'm using HTML and Java Script. where will that database system be. Because I'm using freewebs to make my website.

[Karmic]

Well, neither of those languages provides any database connectivity, on account of them both being client-side languages (and HTML is a markup language).

You'll want to look into server-side languages. PHP is a very popular choice. VBScript (on the ASP framework) is another one. I'm not sure which languages Freewebs supports, but I have an inkling it doesn't support any at all. So first you'll want to find a better webhost, or ideally set up a server on your own computer.

In another topic you said you knew VBScript. How much experience exactly have you had with it? And how much do you know about coding web applications? If this is your first foray into programming, I strongly suggest you start with something easier than an online game. Again, reading books and tutorials on databases, programming in general, and a bit about computer hardware would be a great start.

[Grash]

While I haven't touched it myself; I hear PHP and mySQL go very nice together.

[Glorifindal]

I only know a little VBScript. Karmic do you know about flash, that's what I use to make simple games!

[Karmic]

The PHP-mySQL combo Grash mentioned is pretty nice, yes, and they're free as well so it fits a beginner's budget pretty well.

As for Flash, I've no experience with it myself.
How complex a game exactly are you trying to make here?

[Glorifindal]

Not real complex I'm just trying to make a game like HoA except for you won't be able to do as much.

[Karmic]

Okay, that didn't really say anything...

Still, I reiterate my earlier suggestion - pick a programming language and start learning it.

[Glorifindal]

Ok, Karmic there will be less territory's and areas. As well as you heroes sadly won't have names.

[Karmic]

If you say so.

[Glorifindal]

So Karmic does it cost money to get a database?

[Karmic]

MS Access comes with Microsoft Office, so in a sense it's free (if you already have Office on your computer). Also, I believe you can create Access databases through ADO, so you don't really need MS Access either, though it certainly will make creating and designing a database easier.

MS SQL Server Express Edition is free. It even comes preinstalled on Windows Vista Business. Also, the SQL Server Management Studio Express that goes with it is really nice.

MySQL is free. phpMyAdmin, a web utility for managing mySQL databases, is also free.

There are probably more free database solutions out there, but these are the first few that sprang to mind.

Which one you choose depends on your programming language of choice. If PHP, get MySQL. If ASP or ASP.NET - get either Access or SQL Server. The choice between these two will depend on what the server will support. Most Windows-based hosting platforms will support Access databases, but not all might have SQL Server installed, though it's a much more robust and overall better solution than Access.

[Glorifindal]

OK, I've chosen MS access and I have Microsoft office 2007 and an XP computer. So then where do I find MS Access?

[Karmic]

In the Start menu? Assuming you haven't changed anything there, look under Start -> All Programs -> Microsoft Office -> Microsoft Office Access 2007.