MySQL is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. It is downloadable from mySQL website (http://www.mysql.com) and tailor it to their needs in accordance with the general public license. MySQL is noted mainly for its speed, reliability, and flexibility.

By: James Crowley Published: 09th Apr 2002 Type: Tutorial Rating: Introduction This article was contributed by James Crowley from DeveloperFusion.com . If you're after free programming tutorials, source code and reviews you can click here A common requirement when designing a site is the ability to update the layout and HTML of the site without having...   Read Article.

By: Joe O'Donnell Published: 27th Apr 2002 Type: Tutorial Rating: Introduction One of the many cool things that I seem to notice when browsing around the Internet is the quot;xxx users currently onlinequot; feature of many web sites. Counting the number of users that are currently browsing your site is a great way to brag about your high number...   Read Article.

By: John Ferme Published: 03rd Mar 2002 Type: Tutorial Rating: Introduction There are dozens of reasons why programming languages such as C++ and Perl are extremely popular and have millions of dedicated developers all over the world. Besides being powerful and offer a robust syntax, both of these languages also have several add on modules (MFC for...   Read Article.

By icarus June 28, 2001 Zen And The Art Of Recruitment It might not seem all that hard, but manning an organization's Human Resources division is actually a pretty difficult task. Sure, HR guys and gals don't have to worry about memory leaks, garbage collection or mangled code; however, their problems are often just as compelling and challenging...   Read Article.

By icarus July 11, 2001 Unfinished Business In the first part of this article, I explained some of the problems typically associated with data management in a HR department, and put together a functional specification for a Web-based application to make the task easier. After putting together a basic database schema and normalizing it, I proceeded to...   Read Article.

By icarus December 21, 2000 Bits And Bytes In the Internet age, information is no longer represented in filing cabinets; instead, it's stored as digital ones and zeroes in databases, data storage quot;containersquot; that impose a certain structure on information, so as to simplify the task of managing and using it. Of course, putting data into...   Read Article.

By icarus January 18, 2001 Slice And Dice Last time out, I showed you how to get your data into a database with the INSERT statement, and edit it with the UPDATE and DELETE statements. And this time, I'm going to show you how to extract specific quot;slicesquot; of data from your database using a variety of SELECT statements. Let's get started!...   Read Article.

By W.J. Gilmore November 27, 2000 Introduction Call me a nerd, but I ll never forget the elation I felt several years back when I first succeeded in connecting a database to a Web page. At the time a newcomer to the world of database administration, I happily began creating all kinds of databases to store my valuable information. However, several problems...   Read Article.

By W.J. Gilmore December 05, 2000 Introduction As your Web application grows in size and complexity, the importance of employing sound design techniques begins to weigh particularly heavily into the project s success and longetivity. Since many of these large-scale productions incorporate database usage, taking time to adequately plan for the scaleability...   Read Article.

By: Mitchell Harper Published: 29th May 2002 Type: Tutorial Rating: How would you rate this article: Bad Good Go » Introduction The database is the heart of most web applications: it stores the data needed for the web sites and applications to quot;survivequot;. It stores user credentials and sensitive financial information. It stores preferences,...   Read Article.

By: Brian Rosner Published: 21st Jul 2002 Type: Tutorial Rating: How would you rate this article: Bad Good Go » Introduction If you were programming a user authorization system for your website, then you would use a session or a cookie to pass data. A session would store the data on the server and reference it by a unique key or ID. As your members...   Read Article.

By: Ben Rowe Published: 29th Jul 2002 Type: Tutorial Rating: How would you rate this article: Bad Good Go » Introduction People love reading news. I know I do. News gives us global intelligence and a sense of awareness in terms of the events happening around us. On the 'net, news sites such as CNN.com, SlashDot.org and our very own Socket6.com...   Read Article.

By The Disenchanted Developer August 20, 2002 Parlez-Vous SQL? A few years ago, I decided to visit Paris for a short two-week holiday. I didn't know French, had never visited the country before, and only knew that it was famous for its wines and cheeses. However, I naively assumed that I'd have no trouble getting around - after all, I reasoned,...   Read Article.

By: Stan Crawford Published: 18th Sep 2002 Type: Tutorial Rating: How would you rate this article: Bad Good Go » Introduction A lot of web sites these days like for users to know that there is a presence of community on their web site. The main focus is simply that quot;you are not alonequot;. One way that a PHP developer attempts to do this is by...   Read Article.

Can't find the information you're after? Try searching our developer forums . By: Ben Rowe Published: 08th Nov 2002 Type: Tutorial Rating: How would you rate this article: Bad Good Go » Introduction Since I first started writing for devArticles.com, I've been asked questions like quot;how do I create a login areaquot;, or quot;how do I create...   Read Article.

Can't find the information you're after? Try searching our developer forums . By: Mitchell Harper Published: 05th Nov 2002 Type: Tutorial Rating: How would you rate this article: Bad Good Go » Introduction It seems that every site provides an RSS XML feed these days - even we do . But what is an RSS XML feed, why would you want to create one,...   Read Article.

Can't find the information you're after? Try searching our developer forums . By: Ben Rowe Published: 12th Nov 2002 Type: Tutorial Rating: How would you rate this article: Bad Good Go » Introduction In this article -- using the class files from the previous article -- I'm going to show you how to create a login/logoff area. I will also...   Read Article.

by Daniel Solin 10/24/2002 A little while ago, I was working on an intranet site for a mid-sized company. As the site grew in both size and popularity, the assigner requested me to extend the site with a search feature. Since one of the rules of the intranet was that all logic code should be written in-house, using an existing open source engine was...   Read Article.

By Stig Saelig;ther Bakken with Zend staff April 17, 2000 Intended Audience How PHP came into being Why yet another language? PHP 4 Architecture PHP 4 Architecture Language Syntax Embedding PHP Code Dynamic vs. Static Web pages Variables Arrays Conditionals and Looping Constructs Web Application Features submit.php Working With Cookies Built-in Variables...   Read Article.

Barry Wise ( itcn.com ) One of the most important factors in dynamic web page development is database definition. If your tables are not set up properly, it can cause you a lot of headaches down the road when you have to perform miraculous SQL calls in your PHP code in order to extract the data you want. By understanding data relationships and the normalization...   Read Article.