Tag Archives: mysql

Subquery Problems in mySQL

Posted on Thursday, 4th Oct 2007 by Caz

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 →

Posted in development | Tagged , , , | 2 Comments

A Stitch In Time

Posted on Wednesday, 29th Aug 2007 by Caz

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 →

Posted in development | Tagged , , , , | 6 Comments

Disconnected

Posted on Thursday, 22nd Mar 2007 by Caz

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 , , , , , , | 1 Comment

Cowboys (Me) And Indians (That'll be Apache)

Posted on Wednesday, 6th Dec 2006 by Caz

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 , , , , , | 1 Comment