Copy a record within the same table MySQL
Just a simple copy record function. First of all, pick a random temporary table name, and ensure you don’t have a table in your database by that name. Then, copy…
A bunch of ramblings about PHP programming, JQuery, MySQL and other 'stuff'
Just a simple copy record function. First of all, pick a random temporary table name, and ensure you don’t have a table in your database by that name. Then, copy…
To install MySQL on Centos is a little different from Ubuntu – as I found out. Obviously APT is replaced with yum on this flavour of Linux, but not only…
I often set up mysql query logging when I am diagnosing a problem. In the my.cnf file, enter (or update the log parameter) log=/path/to/logfile.log Remember to restart the mysql service:…
Wine doesn’t always play well with MSI files, so I have to install them through the terminal: wine msiexec /i <installationfile>.msi You may have to sudo the command
Its fairly very simple to get a changelog from Subversion when you know the revision numbers you are searching for: svn log -v -r3500:4000 http://svn.domain.com/trunk > /tmp/changelogs/4000.log The above will…
Don’t use DATE_FORMAT when trying to assertain the latest date in a table. It won’t work. DATE_FORMAT will convert the dates to a string, and then the MAX will compare…
http://odyniec.net/projects/imgareaselect/ I have been using this excellent jQuery plugin which allows the user to draw a lasso around several objects to highlight then and bulk change them. However, they way…
I found that no matter what I tried, I could not get Google Talk to work through Empathy (on my Google Apps account) I fixed it by adding it as…
PEAR (PHP Extension and Application Repository) is a bunch of extensions you can install on your server to uitilise clever ‘extras’ that other people have spent their time writing. To…