12 Nov
Detecting when self=parent in MySQL
Usually, it's a bad idea to allow elements in a tree to be parents of themselves, because that creates problems with trying to add other...
MySQL
by Dave Poole | Comments (5)
by Dave Poole | Comments (5)
27 Apr
MySQL Tidbits: One-shot Page Ordering
One of the common needs for a content management system (hey, that's what we make!) is some form of page ordering. Clients need to be...
MySQL
by Joe Izenman | Comments (2)
by Joe Izenman | Comments (2)
13 Oct
Variable Resolution In Server Side Cursors
I was working on a content retrieval procedure recently, and hit a snag. I needed to retrieve the content of one field, do some other...
MySQL
by Joe Izenman | Comments (0)
by Joe Izenman | Comments (0)
10 Oct
Goto Code in PHP
Sometimes, you just need a way to GOTO. Here is a little trick that will duck out of a section of code using break The...
MySQL
by Paul Sayre | Comments (9)
by Paul Sayre | Comments (9)
6 Oct
Stats In MySQL Pt. III: Alphabetical Distribution
Not as snazzy-looking as my last two, but a useful query nonetheless. One the applications we built over the years, among other things, takes a...
MySQL
by Joe Izenman | Comments (3)
by Joe Izenman | Comments (3)
Page 1 of 5 >>
