Site Search

This search allows for boolean searching. Words must be greater than 3 characters, and will be ranked by relevance. Results will be displayed on this screen.


Search Options


Search Results
using mysql DATE_FORMAT
Formatting dates can sometimes be a bit of a pain when selecting very cryptic timestamps from a database. mySQL has some very powerful formatting opti
http://gavinbenda.com.au/2007/04/03/using-mysql-date_format/

backing up mysql easily
Losing databases is a developers nightmare, so it's really important that they are kept safe. Files are always easy to keep a backup of locally,
http://gavinbenda.com.au/2007/05/31/backing-up-mysql-easily/

mysql joins and data mapping
When you start dealing with large sets of data, you really need to think about your database design and how it will scale in size and for different pu
http://gavinbenda.com.au/2007/06/28/mysql-joins-and-data-mapping/

mysql UPDATE tips
Seen a few applications/examples which could easily be modified to run a little faster. Suppose you wanted to record page views, and add to a tota
http://gavinbenda.com.au/2007/07/25/mysql-update-tips/

dates and times in php and mysql
There are so many different methods of storing dates and times in mySQL fields - and the same goes with generating dates/times from within PHP. To ad
http://gavinbenda.com.au/2007/08/21/dates-and-times-in-php-and-mysql/

Pagination in PHP and mySQL
Another little mini-tutorial to a commonly sought-after feature in a lot of applications. When you are dealing with large sets of data, i.e. thousand
http://gavinbenda.com.au/2007/10/04/pagination-in-php-and-mysql/

join two tables in different databases
Interesting little tip that I must admit never knew was possible (although admitadly, probably isn't needed to be used *that* often). Suppose
http://gavinbenda.com.au/2007/11/07/join-two-tables-in-different-databases/

Cloud Map