New to mySQL need little help

[zakky]

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

[zakky]

Would it be possible to use a .txt file instead?

[Ronald Wernecke]

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.