My first chess video

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 more

Solutions to the ORDER BY RAND() problem.

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;