SQL Current_Date Query Help

vetteguy69 · Mar 19, 2002

Hello,
I am making a data driven site and want an admin page to display a list of people whose birthdays are in the next 14 days based on data from a MySQL database. How would I devise the SQL query to take in the current date and show me the birthdays from the database who are within 14 days of the current date, then display that nicely in a HTML table?
Any help is appreciated.
-vetteguy69

ziyun · Mar 25, 2002

u could try this:

<%@ Language=VBScript %>
<%
dim d, f

d = date() 'get the date of today
f = d + 14 'get the date after 14 days

'setting up the database connection

dim conn, rs, cmd

Set conn = Server.CreateObject("ADODB.Connection&quot

conn.Open "DSN=e-Site;UID=sa;PASSWORD=999999;"

set rs = server.CreateObject ("ADODB.recordset&quot

'sql statement

rs.Open "Select * from testing where birthday >= '" & d & "' and birthday <= '" & f & "'", conn, 2, 2

%>
<html>
<head>
</head>
<body>
<table>
<tr>
<td>User</td>
<td>Birthday</td>
</tr>
<%

if rs.EOF = false then
do until rs.EOF
Response.Write "<tr>"
Response.Write "<td>" & rs.Fields(0) & "</td>"
Response.Write "<td>" & rs.Fields(1) & "</td>"
Response.Write "</tr>"
rs.MoveNext
loop
end if
%>

</body>
</html>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SQL Current_Date Query Help

vetteguy69

Technical User

ziyun

Programmer

Similar threads

Part and Inventory Search

Sponsor