Database Articles Articles

     PEAR::SQLite: The Lightweight Alternative
     Databases and SQL
     Access vs MySQL
     Power Selecting
     Adding a Poll to Your Web Site
     Intro to Databases
     Creating a Search Application
     PHP - Previous and Next Links
     Alternating row colors with PHP and mySQL
     Create dynamic sites with PHP & MySQL
     Multiple Pages of Data from a Text File
     Multicolumn Output from a Database with PHP
     Database Abstraction with PEAR
     PHP/MySQL News with Comments
     Sorting Database Results with PHP
     Writing UNION statements in MySQL 3.x
     A Framework for Persisting Data Relationships
     Storing Images in Database
     Client/Server Communication in MySQL
     Authentication Protocol Security
     Working with Strings
     Connections, Character Sets and Strings
     Working with Cases of Strings
     Pattern Matching with Strings
     Searching with Strings
     Full Text Searches and Strings
     Query Primer
     The From Clause and SQL Queries
     Clauses, Sorting, and SQL Queries
     What`s Code Without Variables?
     Best Practices for PL/SQL Variables
     Oracle Data Structures
     The Basics of Data Structures in Oracle
     Using Indexes with an Oracle Database
     Clusters and Other Data Structures for Oracle
     Query Optimization in Oracle
     More on Query Optimization for Oracle Databases