Phpmyadmin help!! Setting up a database?

I want to setup a database for bands to add themselves to my website, much like myspace for example. I want them to give me the following info:

band name,

band location,

shows,

biography,

songs,

photos,

news

I have the basic mysql knowledge as I'm learning at work as u junior developer, but no phpmyadmin knowledge. I have phpmyadmin installed on my server . Should I set up multiple tables? Databases? I don't understand the field properties. I have spent days reading the documentation on the official mysql and phpmyadmin websites, with no progress. I need some tips or anything. For the love of god help me!!!

Phpmyadmin help!! Setting up a database?

Can you write "basic SQL" to create table or database? If you can then go for it, just hit the SQL tab and then paste you SQL statement there. It's hard to believe you find phpmyadmin confusing. I guess you dont have any idea about Database System

To create a database (supposed you have permission to create one) fill in the database name and hit button create.

To create table, select the database, specify the number of columns in the table. Then a new page pop up with bunch of information about fields you are about to create. Select the datatype of each field, constraint (Allow Null etc), default value etc and primary key for the table. Hit the button create, there you go, you create the table.

If you dont understand what i said. You need to go to wikipedia and read about Relational Database. And please, phpmyadmin is a tool, there's nothing hard about it to understand if you understand basic idea of what database system is.

FirstPrevious12 3 Next End

Phpmyadmin help!! Setting up a database?

Topic