[cancer10]

Hello,
I am developing a simple calender in ASP which will display the next upcoming birthday of my member. Just like some forum have.

I have a table which has 2 column

cname | dob
-------------------
Joe | 9/12/1982
Mathew | 2/17/1997
Pat | 8/23/1880

-------------------
What SQL Query should I use to get the name of that person?

Some basic information:

Database = Access (may be I can upgrade it into SQL Server 2000)

Date Format in database = mm/dd/yyyy

select cname from <tablename>

but you will need to do some other work with that query to make it work for you application

[cancer10]

other work Like?

setting it up to limit it to the current month if in a calendar type view. or if you are querying for each day that is rendered a statement to limit it to that day of that month

[dan.orbit]

Not quite sure exactly what you're looking for, but...

For displaying people celebrating their birthday today (with their age):

PHP Code:

SELECT cname,dob,YEAR(NOW())-YEAR(dob) AS age FROM <table> WHERE DAYOFYEAR(dob) = DAYOFYEAR(NOW());

// Returns 28 as `age` when the current date is 2010-09-12 

Simply display the next birthday of an individual person:

PHP Code:

SELECT MAKEDATE(YEAR(NOW()), DAYOFYEAR(dob)) AS next_bday FROM <table> WHERE cname='<name>';

// Returns 2010-09-12 as `next_bday` for a dob of 9/12/1982 

Cheers