PHP Tutorial: Looping Through & Displaying A MySQL Result Set
Recently I’ve seen a lot of people using while loops to retrieve a single record. You only need to loop through your result set when you expect to get more than one row of...
Tagged: MySQL
PHP Tutorial: Connecting to a MySQL Database
You would think this is really obvious but I see a TON of posts on devnetwork.net (great php/mysql forum by the way) where people put their login and password for their database on every...
MySQL Tutorial: Put table column schema enum values in an array
I hate hard coding enums so you can use this script to get the enum values directly from the table schema. That way if you add or change them you don’t have to go...
C++ MySQL Database Class
/************** * File Name: database.cpp * Author: Design1online.com, LLC * Purpose: mysql database class **************/ #include “database.h” /************** * Purpose: default constructor, initialize class values * Precondition: none * Postcondition: none **************/ database::database() {...
SQL Tutorial: Select, Update & Delete Syntax
Select Statements General Syntax SELECT [column], [column], [column] FROM [tablename] WHERE [column] = [value] Select All Columns SELECT * FROM [tablename] Limit # of Records Returned – MSSQL SELECT TOP [number] * FROM [tablename]...
MySQL & MSSQL Tutorial: Combine Multiple Rows Into A Single, Comma Delineated List
In MySQL with PHP: <? $delimiter = “, “; $count = 0; $loop = mysql_query(“SELECT S.suffix FROM people P INNER JOIN surnames S on P.suffix_id = S.id”) or die (‘cannot select merged data’); while...
SQL Tutorial: Easily Update Rows Based on Complex Joins
There are a lot of times I’d like to update hundreds of rows in a database based on a complex set of conditions. In doing a traditional update SQL statement there is no way...
MySQL FIX: connect to server at ‘localhost’ failed error: ‘Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
In short the error means that mysql isn’t running. So the next reason is, why? Recently I upgraded from php4 to php5 on one of my servers. Ever since then any time mysql does...
