Welcome, Guest
  • Author Topic: New to mySQL need little help  (Read 2399 times)

    zakky

    • Server what's that
    • *
    • Posts: 9
      • View Profile
    New to mySQL need little help
    « on: 12/05/08, 17:54 »
    Hi guys

    1st awesome site, well done.

    I'm trying to setup GuestBook v2, 2 days ago I had no knowleadge of php etc and now I'm getting better and better.
    Could make text saving and loading but I'm bumping my head on the database part.

    How can I create a mySQL database? I've install mySQL on my PC, donno where to go...

    Heres my query

    CREATE TABLE guestbook (
      ID int(5) NOT NULL auto_increment,
      name text NOT NULL,
      email text NOT NULL,
      comments text NOT NULL,
      time datetime NOT NULL default '0000-00-00 00:00:00',
      PRIMARY KEY  (ID)
    )

    Thanks
    « Last Edit: 12/05/08, 18:06 by zakky »

    zakky

    • Server what's that
    • *
    • Posts: 9
      • View Profile
    Re: New to mySQL need little help
    « Reply #1 on: 12/05/08, 21:04 »
    Would it be possible to use a .txt file instead?

    Ronald Wernecke

    • Global Moderator
    • Systems Administrator
    • *****
    • Posts: 6203
      • View Profile
      • Professional Support
      • Email
    Re: New to mySQL need little help
    « Reply #2 on: 12/08/08, 04:33 »
    There are two (at least) version of the guestbook.
    One is using a textfile, tho other a database.
    In the tutorials about loading and saving, you will find all basic techniques to load and save data either to textfile, or to a database.
    You should play around with these tutorials first, to get the basic feeling.
    After you understand these samples, you will be able to choose the guestbook matching your needs.
    happy flashing
    8)
    Ronald