> -----Original Message----- > From: Viorel C [mailto:[EMAIL PROTECTED]] > Sent: 07 January 2002 23:52 > To: [EMAIL PROTECTED] > Subject: hey folks! > > > I'm a newbie in DB administration. Could somebody tell me what do I need > to start a web-based project for book listing, mail lists etc, all > retrieved from a database updated by LAN users and listed on a web page?
Hoo boy, tall order. First off, if you're totally new, go get a book on database design. There are several out there, I think the mysql page even has links to a few. Read, understand. Understand the concept of breaking tables apart - normalization. Once you have your database layout designed, pick a 'web enabled' language - such as PHP3, PHP4 or Perl. PHP and Perl both have 'native' access to MySQL databases - I personally like the Perl DBI because of its portableness. I can write code using the DBI, and it will work against different database engines simply by changing one line. Use a tool like mysqlfront or similar to toss some starting data into the database (or even use the mysql sql monitor). Write your code and test. Be sure to prepare any text that is going into the database so that 's and so on entered by the user get handled properly. Getting data out of the db will be the easy part. Designing the interface to put it in and search it will probably be harder. -- Sapere aude My mind not only wanders, it sometimes leaves completely. Never attribute to malice that which can be adequately explained by stupidity. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
