Where to start? - Beginner Level to Expert PHP Website Developer
Friday, May 15th, 2009This is a message to my previous self (like how Rimmer went back to tell …
Archive for the ‘MySQL’ Category
Migrating from Parallels PLESK/Virtuozzo to CPanel/WHM
Thursday, April 2nd, 2009Recently, I have moved a website from a server running PLESK/Virtuozzo to a server running CPanel/WHM.
I have …
how to create a user on PHPMyAdmin with database-specific access/privileges only
Tuesday, March 3rd, 2009This is quite a confusing process, I found. Even when you are quite familiar with MySQL.
I rarely …
Zend Server has landed
Thursday, February 19th, 2009I’ve just downloaded and installed the Zend Server beta onto my Windows XP computer. It …
How to get Zend Date in SQL timestamp format e.g. MySQL YYYY-MM-DD HH:mm:ss
Saturday, January 31st, 2009Simpletest expectation class that ignores whitespace in Mock Zend Db Queries
Sunday, January 18th, 2009I was trying out Simpletest (unit testing framework) using a mock Zend Db connection that expected …
industrial standard software
Saturday, November 15th, 2008DESCRIBE selecting the PRIMARY keys of a table in mysql
Saturday, October 4th, 2008I wanted to dynamically select the primary key of a MySQL table (tbl_name) in my php code. …
IT Jobs Offered Colchester UK - Recruitment - positions available
Tuesday, October 30th, 2007$recruitment_query = ”
SELECT
*
FROM
tbl_job_seekers as t1,
tbl_skills as t2
WHERE
(
t1.col_job_seeker_id =t2. col_job_seeker_id
AND
t1.col_ultra_geek_score > 99.999
AND
t2.col_skill =’linux’
AND
t2.col_skill =’apache’
AND
t2.col_skill =’php’
AND
t2.col_skill =’MySQL’
)
GROUP BY
t1.col_job_seeker_id”;
$result = …
Selecting MySQL records in time bands from random log data
Monday, April 30th, 2007Lets say you have thousands of log records in a database table that have been inserted at …
