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