Posted by strawberry on 04/22/06 21:44

Frank,

Sure, go ahead and create the tables - see how easy it really is! But
before you go entering ALL the data into this database, get out a pen
and several large sheets of paper and try to make a diagram of the
database. Think about the relationships that the tables have to each
other and the ways in which users will want to look at the information,
and read up a bit on normalisation. I suspect that you're going to find
it more useful to create slightly more than two tables!

FWIW, I started out with Mannish Sharma's tutorial over at
http://www.webdevelopersnotes.com. It's covered in google ads now
(which slightly impede legibility), but it was a good introduction. I
also used Janet Valade's PHP & MySQL for Dummies. I think she could
have covered security in more detail but otherwise it was, also, a very
useful starting point.

Oh, and happy birthday (belated)

[Back to original message]