Page 1 of 1
6 Birthdays!
Posted: Wed Dec 11, 2002 6:12 am
by Paolo
I just noticed this, probably because the line was so long! Six birthdays today. Happy Birthday, folks!
Today's Birthdays: bj (46), dave2 (30), mphilip1 (48), Barry75 (27), love2beused (30), trailtrs1 (49)
Re: 6 Birthdays!
Posted: Sat Dec 14, 2002 6:11 am
by Paolo
Wow, there were 7 today! Check it out at the bottom of the main VBulletin page. Happy Birthday to them!
Maybe we can get some PHP script going to run the records and find out when the day is that has the MOST birthdays here.

Re: 6 Birthdays!
Posted: Sat Dec 14, 2002 4:30 pm
by talula
I will attempt to write just such an item as soon as this damn badger attached to my leg lets go. I do note that 1281 users have entered thier birthday in some way, shape, or form.
Re: 6 Birthdays!
Posted: Sat Dec 14, 2002 5:20 pm
by happousai (imported)
Paolo wrote: Sat Dec 14, 2002 6:11 am
Wow, there were 7 today! Check it out at the bottom of the main VBulletin page. Happy Birthday to them!
Maybe we can get some PHP script going to run the records and find out when the day is that has the MOST birthdays here.
Here's a MySQL query that you can use to do this for vBulletin. The PHP script itself wouldn't have to do any calculations; it can just display the result from the query.
mysql> SELECT DATE_FORMAT(birthday, '%m-%d') AS birthday,
COUNT(*) AS count
FROM user
WHERE birthday != '00-00'
GROUP BY birthday
ORDER BY count DESC LIMIT 20;
+----------+-------+
| birthday | count |
+----------+-------+
| 05-05 | 15 |
| 04-20 | 14 |
| 11-25 | 12 |
| 01-01 | 12 |
...