As a surprise to our forum members, we decided to instigate a competition without telling anybody...
How so? The winner of this competition must have at least one post and must be a member of our forums (not staff or banned). The winner will receive a iqua BHS-701 Bluetooth Music Headset, and will be drawn at random from our member database by a nice SQL Query:
SELECT * FROM ibf_members where mgroup = 3 and posts > 0 order by rand() limit 1
This will select all our members with one post or more, ordered at random, but showing only the first one from the random list. There will be two tests of the query (to prove it works) and then a final winner will be drawn. This is a fair method of selecting one random winner.
The Results
The time of this draw is 19:13 (GMT) on the 15th January 2007 - winners selected at random by MySQL.
Test 1: Ciaran (ID: 11)
Test 2: Jace (ID: 12)
Winner: Marc (ID: 20)
Congratulations to Marc for winning - everybody else watch out for more competitions coming up. Thanks to iqua for providing the prize.
How so? The winner of this competition must have at least one post and must be a member of our forums (not staff or banned). The winner will receive a iqua BHS-701 Bluetooth Music Headset, and will be drawn at random from our member database by a nice SQL Query:
SELECT * FROM ibf_members where mgroup = 3 and posts > 0 order by rand() limit 1
This will select all our members with one post or more, ordered at random, but showing only the first one from the random list. There will be two tests of the query (to prove it works) and then a final winner will be drawn. This is a fair method of selecting one random winner.
The Results
The time of this draw is 19:13 (GMT) on the 15th January 2007 - winners selected at random by MySQL.
Test 1: Ciaran (ID: 11)
Test 2: Jace (ID: 12)
Winner: Marc (ID: 20)
Congratulations to Marc for winning - everybody else watch out for more competitions coming up. Thanks to iqua for providing the prize.

