(Ian Gilfillan) If procedural programming is new to you, you may be wondering what the difference is between a Stored Procedure and a Stored Function. Not too much really. A function always returns a result, and can be called inside an SQL statement just like ordinary SQL functions. A function param

(Terri Wells) The question of which platform is better for running a business, Windows or Linux, has inspired debates that are nearly religious in their vehemence. Two studies came out this year that purport to settle the question, at least when it comes to issues of security and reliability. Do the

Today SOAP API’s, XML, RSS feeds and even remote database access have given companies the ability to cooperatively exchange data easily and efficiently. These content exchange services make it easy to share information, but have not always been available to small businesses. In the past, some compan

(Scott Nelson) If a picture is worth a thousand words, a live demo is worth a million. The problem is that a live demo takes as much work as the real thing and is frequently a throw away. Quality demos also can often require almost as much hardware and software as the final product, making it diffic

(Edmond Woychowsky) MySQL is “The World’s Most Popular Open Source Database,” at least according to the MySQL Web site. But in spite of this popularity many corporations are resistant to adopting MySQL. There are several reasons for this, from the misguided belief that open source is the software eq

The MySQL open source database has gained attention over the last few years as a low cost database option. The feature set of MySQL has increased during this time to include many of the things that enterprise class applications require including transactional integrity, foreign keys, and support for

(StylezHouse) A porting of the ASP.NET reporting starter kit to use Mono, MySQL and Apache on a Linux system.

(Paula Rooney) Red Hat will launch certification and support services for leading open-source LAMP and Java stacks beginning in the first quarter of 2006.

(Drew Decker) CHMOD (chmod) is a UNIX oriented command that means “Changing Mode.” It lets you change the mode (hence the name) of the file, or directory(ies) depending on how the chmod command is used. When I say “changing mode,” I mean giving the file a different permission scheme, respectively re

So far we have seen a couple different forms of queries. This is to be expected as nearly all MySQL in PHP is done through the MySQL Query function. We have created a new table and inserted data into that table. In this lesson we will cover the most commonly used MySQL Query that you must be sure to