Okay, now that I've posted the way MySQL codes worked, I think we should move on to the codes.
Basically, I only use a few of the MySQL scripts as shown below:
1) INSERT
The way this script works is simple. Here's the syntax:
INSERT INTO('table_name') VALUES('data_to_be_added1', 'data_to_be_added2');
I hope you'd notice that when you use MySQL, it works where:
- The user logs in
- The first layer, the first group of gathered data, is the database
- The database contain tables
- One user can have several databases, and each database can contain several tables.

2) SELECT
This syntax is used to fetch data from a table.
SELECT column_name FROM table_name;
To select contents of all columns, the column_name field is filled with an asterisk (*) sign. This syntax can have an additional order, WHERE to select a specific row content.
With it, the syntax will be SELECT column_name FROM table_name WHERE='content_specification';.

3) UPDATE
This syntax is used to update a table content, may it be specific or all at once.
UPDATE table_name SET column_name='new_content', column_name2='new_content2';
This syntax could also use a WHERE addition.
UPDATE table_name SET column_name='new_content' WHERE='content_specification';

Those were some basic MySQL codes. To execute them, the PHP code is mysql_query($query,$mysql_id); where the $mysql_id variable is a fetchback result of the order mysql_connect(). The connection had a connection ID, and it's what the $mysql_id variable keeps.

Oookay, I'm a little depressed here because there are so many things I need to talk about here and the lack of time I have. So, let's assume you've mastered several basic PHP Codes. You'll need the repetition statements (FOR, WHILE, DO-WHILE), conditional expressions (IF, IF-ELSE, IF-ELSEIF), and a basic like PRINT.

The Expressions here doesn't refer to how your face looked in moods, but to a functional parameter in some PHP basic functions.
First, try making a file in your host and name it 'if1.php'. Then write these down:

<?php
$name = "Anton";

if($name == "Anton")
print("Welcome, Anton!");
?>

Those short script will have an output about like this:

Welcome, Anton!

Now, for the explanation. The term $name = "Anton"; creates a new variable called $name containing a string (a text or a line of characters that can be either alphabetic or numeric, and doesn't work as in for numeral processes like plus or multiply) "Anton". And then the function if() works as the conditional function. It states $name == "Anton" which pretty much means if the content of variable $name contains the string Anton. If the value of the test is true, then the statement print("Welcome, Anton!"); is executed. Keep in mind that it uses two equal signs (==). It means it does NOT create a variable, instead it checks the content of the variable whether it's the same as the conditional string (or content) or not. There is also three equals (===) to make difference between "1" with the boolean (true or false values, sometimes outputs 1 or 0) "TRUE" and "0" with "FALSE". There are also > (greater than), < (less than), >= (greater than-equal to), <= (less than-equal to), and != (not equal to). The first 4 can only be used in numerical operations, like if($number > 5) (the script means 'if the content of variable $number is greater than 5, but the statement to execute isn't written. Well, it's just an example, right?).
Now edit the if1.php and change the content of $name into "David", and add these after the print() on if():

else
print("Welcome, guest!");

The result will be:

Welcome, guest!

Why? Because we added the else() statement after if. This made the if() have the if()-else() form. The cause is, when the test on the if() returns FALSE value, then the statement on else() is executed. Like, if you're going to a mall, and you faced a two-way road. If you know that the road left side heads NOT to the mall, you'd go to the right side road. Like if(left_side_road heads to "mall"){ goToLeftSideRoad; }else{ goToRightSideRoad; } if you understand what I mean. In that case, I also used another form of if():

if(logical_test)
{
statement_if_true;
}

The underlined parts made it. Yup, it's if() with brackets. These are useful if the statement to execute under if() took more than one line. For example:

if(logical_test)
{
print("statement_1");
print("statement_2");
}

That if contains 2 statements to execute if the value is TRUE: the first print and the second one. Get it?

On the next meeting, we will talk about another conditional expressions. Keep your eyes peeled AND never get bored on learning!

ANOTHER FORGOTTEN POST.
To start with PHP, you must at least install WAMP Server on your computer, or if you want the world to see your game, get a free hosting at the internet.
I'd recommend www.freewebhostingarea.com. It is free, it has short subdomains, and its file host is easy to use. To make/edit files, delete files, even with compressed files like those with *.zip or *.tar.
Another feature is that one email account can have multiple websites in a same server, like I have archaeozoic-area.6te.net and pals.6te.net on 6te.net server.
Not to mention it is trustworthy AND has a free 24/7 customer service. I'm not here to promote a brand, but this is the hosting I'd recommend you the most.
I think you'd better use 6te.net or ueuo.com because they have short subdomains and were not banned by FB (freetzi.com was reported abusive somewhy). To register, go to the server address (e.g. 6te.net) and add /create22.html behind the main link (e.g. ueuo.com/create22.html) in case the two servers doesn't appear in freewha.com combobox.
So, now with hosting, plot, and some basic programming, you can start training to make your own game!

This step includes the basic data processing thingy.
Now, make a new file and name it interface.php.
Write these down:

<form action="process.php" method="post">
<input type="text" name="name">
<br />
<input type="submit" value="Send">
</form>

The outcome is about like this:

Actually, the whole file was made of HTML codes, but it's fine to keep it with .php extension. The action="process.php" parameter sets the destination file when the 'Send' button is pressed. While the method="post" sets the method used to send the data input. Then the name="input" parameter on <input> tag names the inserted data as "input" for the superglobal $_POST. You can change it into "name" or anything else, but don't forget to change the name parameter in the box bracket on the new codes below.

Now make a new file, name it process.php, and type these codes in:

<?php
$name = $_POST["input"];
print("Hello, $name!");
?>

It's short, but when you input the name on the interface.php and pressed 'Send', it'll print:

Hello, *name_input*!

You can change the $_POST["input"] into $_POST["name"] or anything as long as it's the same with the text input's name, so the data won't be lost in the middle of the process.

For an instance, you enter "Chloe" on the text input and name the input "name", then the process.php must be changed first, change from $_POST["input"] into $_POST["name"].
OK, after it's changed, you can enter the name as you wish, like "Chloe" in our example now. Type it in, then press Send.
You will see the screen writes 'Hello, Chloe!'
The codes are short, but now you can have some interface basics. Now try this for another kind of experiment.
Open interface.php in editor mode, change the method into GET (method="get"). Then in the process.php, change the line $name = $_POST["input"] into $_GET["input"] (those examples showed the text input named as "input", if you name it with another name, be sure to change it as well).

When you enter a name,for instance "Anton", here's what you get in process.php:

Hello, Anton!

But look at the address bar. Taking example that the text input is named "input", here's what you get in the URL:

http://your_web_address/process.php?input=Anton

The underlined part shows you what the GET method does. See why it's called URL rewriting?

Now you should have some idea about processing data from form inputs. On the next meetings, we'll start with basic operations like if(),if()-else(),for(), and some more and see what they can do.

Now time to start with PHP. First of all, I must warn you NOT to freak out if you faced an error, so don't be like me. Second, let's roll.
PHP is a kind of interactivity-creating browser-based language. This is what we'll use in the game making in this blog.
PHP codes are easy to notice. They start with <?php and ends with ?>. You'll also notice a lot of $ signs in the codes. The words after $ like $username is called variable, while the capital letters after $_ with parameters in box brackets like $_GET["name"] is called superglobal. The example variable we can call as 'username variable' while the superglobal is 'GET superglobal' (this superglobal had things to do with data sent through GET method from the form as explained previously on Step 2).

Here is an example of PHP code:
<?php
$name = "Alfi";
print("Welcome, " . $name . ".");
?>

Save it as php_try_1.php (note that the file format is .php).Those codes will create this outcome if you have a PHP supporting server or works with a file hosting that supports PHP:

Welcome, Alfi.

Dull, huh? Don't be mistaken, the print(""); function is pretty useful, we'll use pretty much of it later. Notice that the variable making ($username = "Alfi";) had "" marks to start and end characters (this differentiates characters like words and functions like print()) and ends with a ';' and so as the function. DON'T MISS THAT SIGN. Without it, the parser (the syntax checker on the server) would send an error message about Unexpected $end on *file_address* on line x.
Talking back to our first script, the print() functions works as an order to display characters on the monitor. For an instance, check our previous code:

print("Welcome, " . $name . ".");

It'll print the words 'Welcome, ' (with a space). Then the " sign after the space after the coma sign ends the words to be printed. Then there's a space and then a dot and another space, it works as a connector for an instant print through another function — in this case, through a variable. Then another connector, then the codes "." prints the '.' (dot) sign.
OK, maybe I explained a little too fast, so take a deep breath.
*Inhales deeply.*
*Exhales.*
OK, back to business.
The earlier functions prints the words 'Welcome, ' and then the content of the variable $name, and then a full stop mark.
Because we are printing a variable (and not a function), you could also make the codes written like this:

<?php
$name = "Alfi";
print("Welcome, $name.");
?>

It would have the same outcome. Now change the value of the $name into "David". It'll print this:

Welcome, David.

So, it's an example that a variable IS a variable — it can have various content. This is useful for game data keeps, and some interactions.

Try this too to see what PHP is capable of. Edit the source files of php_try_1.php and change the earlier codes into these:

<?php
$name = "Norbert";
print("Welcome, $name. Right now it's " . date("d M Y") . ".");
?>

It'll have an outcome like this (e.g. it was 6th of June, 2010):

Welcome, Norbert. Right now it's 06 Jun 2010.

Notice that the print function used connectors to print the date() function. Nice results eh? The date() function checks the time on server. While the "d M Y" indicates the format of the time writing. In this case, it uses a small 'd' which means date in two digits (06), a capital 'M' which means month in three letters format (Jun), and a capital 'Y' which means the current server year in four-digits format (2010). There will be a list for the indicators for this function later, but be patient because we had a lot to talk about — and the multiplayer version of our RPG requires MySQL database, which would get you some extra stuff to think about.

However, that's for now. In the next part, we'll talk about making the content of the variable through an interface with the HTML codes we knew and using some superglobals.

Now, to tidy things up in your game, you'll need to make tables. You can start by the <table> tag. Then, you add one row with the <tr> sub-tag. Then you can start adding a cell by the <td> sub-tag within the <tr> and </tr> tags.
Here's an example code:
<table>
<tr>
<td>
Cell content 1
</td>
<td>
Cell content 2
</td>
</tr>
<tr>
<td>
Cell content below 1
</td>
<td>
Cell content below 2
</td>
</tr>
</table>

And the result is:

Cell content 1	Cell content 2
Cell content below 1	Cell content below 2

If you've got what the codes do, you can start making your own. Trust me, this is a piece of cake but it's pretty useful. It might came in handy sometimes!

The post earlier had some basic HTML you'll need, like Bold Text, or Italic Text, or making a link, or making some settings over a text.
But in real game, you'll need a lot more.
Which is why the post is here. I'll write these down before I forgot.

Tag	Result
<form>	*It's incomplete. It needs sub-tags to add the content.*
<input>	*Incomplete. It needs parameters. Explained below. It's sub-tag for <form>.*
<textarea>Text</textarea>	Text *It's another sub-tag for <form>.*
Text<br />Text 2	Text Text 2
Text</p>Text 2	Text Text 2
<hr>

Tips:

• The <form> tag ends with </form>. But be sure to have the <input> or <textarea> before the end tag, because when you click the Submit button, all data from the form tag will be sent, based on the method sent.
• There are 2 data sending methods for <form> which are POST and GET. POST method sends the data through the server, so it's 'invisible'. While the GET method sends the data through URL (URL rewriting). This could be useful in some cases.
• <input> tag had many kinds. You can add parameters to determine its type. Like, add type="text" to make a one-line text entry (e.g. for Username field in Login form). The type="password" makes a password input field. type="submit" type makes a button that sends all the input data from the <form> tag to the </form> tag end. The type="reset" resets all the data input within the two form tags. While type="image" makes an image that works as the type="submit" button (sends all form fields through one of the methods to be processed). Check Archaeozoic Area, then when you can view the whole Home page, right click anywhere and choose 'View page source...', locate the form or input tags, and see what they made. Then choose Register, and do the same. This will get you even deeper understanding about the tags for the form. THESE TAGS ARE VITAL FOR GAMES.
  

Almost forgot to post this one! Before you start making your game, it is very recommended to write down your ideas in a piece of paper, or type them down on MS word. For example, you want the multiplayer battle feature in your game where the player must choose the enemy first. You'll need a name for the feature, because 'Multiplayer Battle' on the menu just sounded pretty dull. So, you might want to name it 'Battlefield', or 'Asteron Arena' (for outer space themed games), or stuffs you can create on your own. Then the facilities headquarter, you may name it 'Kingdom' (like in Dracoterra), or 'Camps' (like in Archaeozoic Area), or 'Headquarters', or 'Ship Stations' (like in Operation H.E.L.D), or such stuff.
Now, while your ideas are popping out like popcorns, write them down quickly! Now that you have the basics you'll need, we can start from the beginning (check Step 1: Preparing the CSS Files to start making the layout for your game).

HTML is the very basic of web programming. Try not to use Dreamweaver, because it'll make you less creative. Try Notepad or the web host's file editor instead.
Here is the list of some tags you'll need to understand:

Tag	Result
<b>Text</b>	Text
<i>Text</i>	Text
<a href="http://archaeozoic-area.6te.net/">Link Text</a>	Link Text
<font size="3" color="#ff0000">Big Red Text</font>	Big Red Text
<img src="http://archaeozoic-area.6te.net/php_icon.gif" />

Tips:

• On the link codes, you can add target="_blank" after the href="http://web_address" to make the link opens in new tab or window when clicked. And, in this game tutorial, instead of href="http://complete_web_address" we'll use href="filename_in_the_same_root_folder_(same_site)". It'll make the link shorter, but as functional as it is supposed to be.
• On the font settings, you can change the size as you wish. You could also set it through the CSS, so you don't have to add <font> tags each time you type some text on the game-making progress. Then, the color can use hexa-based color chart like in the example (#RRBBGG), or it can use texts like color="red". *R: red, B: blue, G: green. Here's the chart: http://www.web-source.net/216_color_chart.htm
  

It's easy to ask yourself whether you can make your very own game, but could you do it for real?
I'd say, yes.
I'll give you some 'how-to's about making games, based on 3 Languages you'll need a lot:

• HTML (of course, it's the basic)
• CSS (you don't want your page to be dry, do you?)
• PHP (without this thing, your game interacts NOT)

So, first I'd recommend you to find the images you'll need for your game (including background, content background, sidebar background, splash, and stuff. Maybe even your company logo), make some splash text and save it (can either be in MS Word or Notepad, or such program) then check this page: http://www.subcide.com/articles/creating-a-css-layout-from-scratch/

Trust me, although it says it's out of date, it's VERY useful. Make your own CSS for the home page and stuff, and save it in the folder /css and name it style.css. Then make another CSS file, this time, make a layout for your game (with sidebar, link settings, table settings, and stuff that a game interface would have), and save it in the same folder with the name style-game.css, and if you're finished, you already had one step forward.

Tips: It is HIGHLY recommended to use link colors that match the theme of your game, and the background of your game's content holder (<div id="content">_game_contents_</div>). E.g. the game theme is jungle, the color is dark, then you can use #00FF00 green as the link color.