Signs

Enter « Hiatus « Moved « Welcome «

Downloads

Bookmarks « MSN Display Pictures « Templates « Transparent PNGs «

Tutorials

Articles « Cute News « Misc. « PHP and MySql « Photoshop « Tables «

Affiliates

Beloved-Melody « Bouncing-Kitten Designs « Final Summoning « Lunar Bliss Graphics « Starry Night « Affiliation «

There should be a drop-down menu in the left-hand corner, find your newly made database here:

As you can see, when you click on it a new page comes up and says No tables found in database. But towards the right side, it also says something else.

Type in the desired name of your table (this is where your content will go, such as layouts, pngs, etc.) Calculate the number of fields you want, but make sure you have enough to make one with the name ID.

I have three fields for my sample:
ID, anime, and type.

It is also important to add a field which all your data will have the same so that you can sort them by that later. For instance, if yoyu want to have a layouts database and wish to sort them by Divs, type in Divs as the type. (although you don't have to have the word type). Or for something else, its category name. Why else do you think all my Transparent PNGs say Type: PNG?
In truth, it doesn't matter what you have, because you don't have to display the thing that all the content in your tables has in common and I will show you why later.

Back on track, now that you've made the table a new window should come up.
.

Take note as to what my ID field has to every last detail. Yours should look the same as well. After your ID field, all the rest of the fields have to the same inputs as my anime and type fields. (Type as VARCHAR, lengh with 255)

Adding data:
Once you save this, a table should appear in the left corner! O_O
If you click on it, you will see all the things your new table has. To insert data, click Insert in the top corner.

Type in all the information you need, but leave the ID field blank! You will also notice there are two identical boxes you can enter your information. Make sure the Ignore is checked and leave the second box blank.
After that you can choose to Go back to previous page Insert another new row. Viewing data:
Click the Browse button and here you can choose to modify (), or delete () your rows.

Explanations:
Length/values: the maximum number of letters/numbers you can have in your table every time you enter data into it.
Extra (auto_increment): This is specifically used when adding the id, because the number increases by itself and you don't have to enter anything in this field!
Primary key: Something in your table needs to have this selected, because if it doesn't SQL will get screwed up.

You can now go on to the third part of this tutorial to see how you can display your data!

Website

Main « Set as homepage « Add to favorites « Apply for Staff « Contact Us « Credits « Link Us « Staff «

Vote for us!

«

Sponsors

Beloved-Melody « Kyuusho «

Status

Extreme Tracker « fragile beings « 38.103.63.17 «