database for site

Discussion in 'MySQL' started by semperfi0222@gmail.com, Jun 22, 2009.

  1. #1
    Hey everyone,

    I'm looking to create a database for a site that I'm creating where people would post their info when they register for my site and then other people will be able to see their info.

    Now what kind of program should I use to create a database?
    Is it possible for the database to be automatically updated on my site once a new user registers and enters their info?

    I would really appreciate some advice

    Thanks to all that reply.
     
    semperfi0222@gmail.com, Jun 22, 2009 IP
  2. gauravajitsaria

    gauravajitsaria Peon

    Messages:
    309
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    hi.
    if u expect a huge number of queries, its better to work with MySql. Its free, easy to use and works on all platforms.
    all database softwares can be autoatically updated by using the update, create and the delete commands. u just need to get the code right.

    all the best, try to work on it.
     
    gauravajitsaria, Jun 24, 2009 IP
  3. haylander

    haylander Peon

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    use the sql command to creat and edit databases "create databaasename"
     
    haylander, Jun 24, 2009 IP
  4. paulv200

    paulv200 Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If you have a web site then you should find out if your hosting has mySQL database and a control panel. You will then be able to create a new database using the control panel. To be able to allow users to update the tables will require programming probably in php so you will have quite a lot to learn.
     
    paulv200, Jun 25, 2009 IP
  5. Andrew Shenderuk

    Andrew Shenderuk Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Hi
    use mytaskhelper.com You can create form with fields, which you need and integrate this form to the site.
     
    Andrew Shenderuk, Jun 29, 2009 IP
  6. catchball

    catchball Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I suggest you use a sql system .. the system is extremely easy to use
     
    catchball, Jun 29, 2009 IP
  7. shaibibutt

    shaibibutt Member

    Messages:
    606
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    35
    #7
    If your web hositing server allows u to have a database then go for MySQl DB.
    create a simple database. u can use my code if u want to

    --

    drop database users;
    create database users;
    drop table usersInfo;
    create table usersInfo (
    NIC int (20) primary key, name char (20), location char(20), emailAddress char(20), gender char(20));

    --
    now just run this code in ur online Db server, either copy paste it or type it manually.

    Now the basic part of ur requirement is done. Now u have to display/Insert the data into the dB table.

    tell me which language u r using for coding, I might help u out. U can run the above code for ur db its fine :)

    PM me if u still need any help
     
    shaibibutt, Jul 1, 2009 IP
  8. Damien6220

    Damien6220 Peon

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    First Check out the columns you want to create and then create and insert table values in it using MySQL plus.GO for a sample DB first.
     
    Damien6220, Jul 5, 2009 IP
  9. alfa_375

    alfa_375 Active Member

    Messages:
    445
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #9
    Like every one says you should go for mysql/php programming sites.
     
    alfa_375, Jul 5, 2009 IP
  10. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #10
    If you are using PHP to develop your application, go for MySQL and if you are developing your application in ASP or ASP.Net got for MSSQL database.
     
    kailash, Jul 5, 2009 IP
  11. hello_welcome

    hello_welcome Well-Known Member

    Messages:
    1,632
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    155
    #11
    for database design you should to choose PHP for MySQL & ASP for SQL and this is best for all
     
    hello_welcome, Jul 5, 2009 IP