If you have a table of GPS data ,that keeps getting written to, and starts to run to millions of records. It is a sensible idea to create a trigger under mysql to update a scratchpad summary table on an … Continued
MySQL Master Slave – Replication
If you need to run mysql replication, then we can help configue it for you, its a fantastic way of allowing you to run reporting against a large dataset, by running all your queries against the slave database, and this … Continued
Texting Solutions
If you’re looking for a text messaging / sms solution for your club or community, we are offering a full service, including allowing you to handle polls and contact your members. Join many other clubs in using a service, … Continued
Ritchie Hunter Website Live
Congrats to Ryan on completing the new ritchiehunter.com site, its a wordpress site that is using media queries to enable it to be viewed sensibly on various different display resolutions. Its using responsive design patterns and is built in … Continued
Using Sum and ABS statements in MySQL
MySQL / PHP Problem I need to sum the number of entries in a table where an id > 0 or an id = 23 Resolution Use a GROUP BY clause in conjunction with a SUM and an ABS SUM( … Continued
Silverarm Solutions Redesign
It’s not a bad complaint to say that you are very busy. It’s probably not ok to say that you are too busy to get around to the jobs that are not under deadline from your clients. Our site redesign … Continued
Setup PHP SSH2 Connection from php to remote box on pair networks
1. Download modules http://www.php.net/downloads.php Download Win32 binaries and extract php_ssh2.dll to the extensions directory Edit the php.ini file that is being used to include this extension extension=php_ssh2.dll Generate a pub / private key pair on the server you wish to … Continued
Serialised Array Walk
This is an array_walk style serialize that works with multi dimensional arrays, it also base64 encodes and decodes to allow ‘;’ to exist in the array.
PHP addslashes to an Array
This is for a solution for adding slashes to a $_POST array when you don’t know if magic quotes is turned on.