Neverside

Purpose of SQL in online community

Is this for user or adminstrator? How this work for online community?

Hope someone can help
Edit/Delete Message

Both. All depends on what you wan't to do with it. Usualy in online comunity DB stores everything from passwords, user profiles to content.

___________________

Right Or Wrong I'm Still The Boss

SQL is how the server side language interacts with the database. Without it it would be pretty damn hard to get anything to work lol. Also the users (and usually admins) never see the SQL, it's all done behind the scenes.

___________________

Do anyone know any tut to teach u how to store the information to database step by step?
I have a login page and it works. But I dont know how to save those data to my database.
I have tried w3school but the SQL statement is always 1 or 2 lines like this
INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)

I am really interest to learn it. Who can give some tips?

What server language are you using (PHP, ASP, CF etc)? What database are you using(MS Access, MySQL, Oracle etc)?

PHP and MySQL are normally a good combination. You need to ask your host to create a DB for you and send you the name, username and password for the database.

Once you've done that, post here so that we can see your progress. Spoono has some good MySQL tutorials.

If you're going to be working with php and mysql, I suggest the PHP 101 tutorial series found on the Zend website. Section 8 covers connecting to MySQL through either php's mysql or mysqli extentions.

Overall, it is one of the better PHP tutorial series I've come across on the internet. I highly recemmend that you read through the entire thing. In fact, I wish it had been out when I first started to learn PHP.

___________________

Bored? Join us at #Central on irc.Neverside.com