Next Five Birthdays

I'm using a MySQL database. I'd like to retrieve the next five upcoming birthdays (column `birthday`) from table `users`. What's the best query I should use for this?

Currently, I'm trying this, which returns an empty recordset:

RS.Open "SELECT `userID`, `username`, `birthday`, `donated` FROM `users` WHERE DATE_FORMAT(`birthday`, '%j') > DATE_FORMAT('" & Date & "', '%j') AND `status` <> 9 AND `confirmed` <> 0 ORDER BY `birthday` DESC LIMIT 5;", Conn

View Replies


ADVERTISEMENT

Showing Birthdays In ASP

I have a table called 'players2005' with fields of 'player' and 'pdob' The 'pbod' is a DATE realted to the players date of birth.

Using ASP how can I call the access database to show members that date of birth is today.
I have the rest of the script but just nedd a SQL statement Code:

View Replies View Related

Selecting The Next Five Upcoming Birthdays From The Current Date

I want to do is select the next five upcoming birthdays from the current date, using ASP + Access. The name of table is "juventude" and the birtday field is "db_dtnasc" ....

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved