Setting up Accounts

[Shawn Northrop]

I am trying to make a website where users can create an account. the account will be a very simple table: Band Name, Genre, Description, Label, Email, Password.
I then want them to be able to add their band name ( w/ extra info ) into another table.

i was trying to find info on how to achieve this but i kept coming up with info on how to create a mySQL account. I cannot do this with my server/this is not my goal.

Is it possible to do this or would the users need a mySQL account?

thanks,
Shawn

[ronverdonk]

You are confusing the meaning of 2 different accounts, i.e. the account you want to setup for each user and a MySQL account.
Your user account is simply some data from a particular user that you store in the database.
A MySQL account is a user who has certain privileges in MySQL itself.
You, or your program, have a MySQL user account (userid, password and privileges).

The process that you need to have is, more or less, as follows:

• Create a table that will hold the future user data.
• Create a html form in which the user specifies his credentials.
• After the user submits this forum, your script stores the user-submitted data in the database table.
• In order to store that data, your program must connect to the database with the account info (hostname, userid, password, database name)
• When you want to retrieve/display the stored data, you also connect to the database and use SQL statement(s) to retrieve the required data from the table.

Ronald :cool: