OW!!!

I woke up this morning with my back hurting, and it still hurts. I think one of the muscles on th middle left side of my back is cramped... Bummer...

Anywho... I got some more colorized drawings up in my gallery. And I've decided that Jim should have glasses (Like the ones I used in my self drawing) as Hobbit suggested. So from now on he'll have big spiral glasses. I'm not exactly sure how they're going to stay on his face, seeing as his ears are above his eyes, instead of along side them, but I'll work something out (This problem has already presented itself in the headphones question...)

I've also worked out a complete SQL query statement for selecting the images in my gallery:

SELECT url, thumburl, comment FROM jtc_gallery WHERE gallery = '$gallery' ORDER BY DESC createddate, createdtime LIMIT $start, 11;

I'll then check the result set and see if there are 11 or less images in it. I'll display only the first 10, and if an 11th result exists, I'll display the Next button. This way I'm not going to cache the whole table in memory just to decide if there are more records. $gallery is a string reference to the name of the gallery, and $start should be a number that marks the first desired record. Both will be derived from the $_GET structure.
- posted by Jim The Cactus @ 11/21/2003 10:24:35 AM | Permalink | (0) Comments. Add your own!