6 Birthdays!

[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)

[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.

[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.

[happousai (imported)]

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 |

...