I might get around to making a series of Chess videos. First, I set out to figure out how. I found that I can record my desktop with the free Windows Media Encoder. I used this site http://bhccvb.blogspot.com/2007/10/how-to-make-chess-videos-on-your-pc.html to learn how. The result of my first stab at this is below. I have a couple problems:
1. Microphone – I need a good one. The one I have sucks.
2. I need Fritz 11 software. I used WinBoard – which is OK, but Fritz is better.
3. Video dimensions. Winboard is rectangular, but taller than it is wide. I need to find a way to make a frame that is ideal for youtube.
Here is the video:
Read the rest of this entry »
I’ve been playing a lot of Chess lately, on the ICC, and I just bumped into this neat utility hosted by the ICC, where I can put a little HTML into my web page, and display a chess game.
Read the rest of this entry »
Just getting them in there, these are not original ideas, I got them from someone else, just wanted to post them on my blog for convenience sakes:
* Run a query to determine the MAX ID number in the table.
$MAX = SELECT COUNT(*) FROM tbl
/* Use PHP to generate a random number between 1, and the max
$ID = RAND(1, $MAX)
/* Run a last query to select the ID that is >= the random one.
SELECT * FROM tbl WHERE id >= $ID LIMIT 1
Another possible solution would be a heavy modification to that query. This solution is likely the best.
New Query:
SELECT *
FROM `tbl` AS `l1`
JOIN
(SELECT (RAND() * (SELECT MAX(`id`) FROM `tbl`)) AS `id`) AS `l2`
WHERE
`l1`.`id` >= `l2`.`id`
ORDER BY
`l1`.`id` ASC
LIMIT 1;