-
Recent Posts
- (Bar)Camping It Up In Blackpool Again
- Hacking Around
- The Curse Of The Generalist
- Customising A Domo – BarCamp Workshop
- BarCamp Slough 2
- Memories Of Telly Centre Part 3 – 2010-2012
- Memories Of Telly Centre Part 2 – 2000-2009
- Memories Of Telly Centre Part 1 – 1988-1999
- FitBit Review – January ’13
- On The Trail Of Wenlock & Mandeville
QR Code
Archives
- July 2013 (3)
- June 2013 (2)
- March 2013 (3)
- February 2013 (1)
- August 2012 (1)
- July 2012 (1)
- June 2012 (1)
- April 2012 (1)
- January 2012 (2)
- November 2011 (1)
- October 2011 (3)
- September 2011 (1)
- August 2011 (3)
- July 2011 (3)
- June 2011 (1)
- April 2011 (1)
- March 2011 (6)
- February 2011 (2)
- January 2011 (3)
- December 2010 (1)
- November 2010 (3)
- October 2010 (1)
- September 2010 (1)
- August 2010 (1)
- July 2010 (1)
- June 2010 (1)
- May 2010 (1)
- April 2010 (1)
- March 2010 (1)
- November 2009 (3)
- October 2009 (1)
- September 2009 (2)
- August 2009 (1)
- July 2009 (1)
- June 2009 (3)
- May 2009 (2)
- April 2009 (1)
- March 2009 (1)
- February 2009 (1)
- January 2009 (1)
- December 2008 (1)
- September 2008 (5)
- June 2008 (1)
- May 2008 (13)
- March 2008 (1)
- February 2008 (2)
- January 2008 (1)
- December 2007 (1)
- November 2007 (3)
- October 2007 (1)
- August 2007 (1)
- June 2007 (6)
- May 2007 (2)
- March 2007 (6)
- February 2007 (8)
- January 2007 (4)
- December 2006 (4)
- November 2006 (9)
- October 2006 (9)
- September 2006 (18)
- August 2006 (5)
- July 2006 (12)
- June 2006 (12)
Tag Archives: mysql
Subquery Problems in mySQL
I’m having trouble selecting data for a web-based application. There are three tables, Articles, Keywords and KeywordsInArticle. There is a many-to-many relationship between the articles and keywords, which is handled by the piggy-in-the-middle KeywordsInArticle table. So, if we have the … Continue reading
A Stitch In Time
I’ve got a probem with date sorting. I have a PHP/mySQL application which requires sorting a dataset by year. As mySQL won’t let you store just the year, I originally used a varchar (text) field to store the year, YYYY, … Continue reading
Disconnected
When I first started cutting my teeth on dynamic web site development, I was pleased that Dreamweaver has plenty of tools to help out. Because we used it at work for sites, I chose the ASP.NET/C# server model, and used … Continue reading
Posted in development, technology
Tagged asp.net, connection string, development, mysql, odbc, oledb, php
1 Comment
Cowboys (Me) And Indians (That'll be Apache)
I’m A PHP Newbie For some weeks, I’ve been meaning to try my hand at some PHP development, having done most of my projects to date with .NET. I bought the excellent book Blog Design Solutions in September, and have … Continue reading
Posted in blogging, development, technology
Tagged apache, blog design, blogging, development, mysql, php
1 Comment