Help with creating a block

Sergeant Joined: Jan 20, 2004 Posts: 80

Hi guys,

In my nuke_users table, I have been gathering birthdates. It's sitting in field "birth" as a date 0000-00-00 (YYYY-MM-DD)

I would like to write a block, which will show which users have a birthday today. Although I am a NEWBIE to sql statements I've finally figured out how to write a statement to get users who have a birthday equal to todays month and date.

Code:

SELECT username
FROM nuke_users
WHERE month( current_date ) = month( birth )
AND dayofmonth( current_date ) = dayofmonth( birth )

I'm proud of writing this! (sooooooo new at any sort of coding)

But I don't know how to turn it into a block to show these users!. Please help. THANKS SOOOOOOOOOOOO MUCH.

Corporal Joined: Jun 16, 2005 Posts: 65

if you are using PHP then just go into the admin panel and select blocks and add it in there.