one more website question.. posted by...

one more website question..

Posted on Aug 10, 2004 03:47 pm
ILLbizzel
ILLbino - one of WA's finest
Member Since: Feb 10, 2004

I would have posted this on the DBmasters site but it doesn't appear to get near the attention as this site gets.

But I've been looking into a login system for my Red Alert Records site. I came across a pretty decent tutorial, but was stuck on the first step, lol. How do you create a Sql database? Do I do that in my website's control panel or create a file and save it as a .sql? What did you use for your login systems (template, create your own?).

Also, maybe you know of a better tutorial or template to use?

[ Back to Top ]

dbmasters
Administrator
Since: Apr 03, 2002

Aug 10, 2004 05:43 pm

If I recall, you host at HostPC. If so, go into your DirectAdmin control panel and click into "MySQL Management" there you can create a database. In that database will reside all your "tables" these tables are made up of columns of data, each column being a different chunk of info. Each record is a "row".

For example, in the HRC database there are about 30 tables. all these tables hold diffent info regarding all the data used for the forums, classifieds, user info, music glossary, links directory etc.

Think of a database as an Excel spreadsheet. The "user" info is stored in a table, let's call it "users" each "row" is for a user. I am row 1, you are row 1003. Each row has the same set of columns. One column is the username, one is the password, one is the email address, etc. Each form field in your profile represtents a column.

In setting it up you will assign it a name, a user and a password. You need this info to get access to the data within it.

ALl of my scripts are hand coded by me, I started learning coding by using other people stuff, looking at it, seeing how it works and them using that knowledge to write my own.