OK. Im making an admin panel for my bands site. i have it so i can update news and whatnot, but im kind of stuck with the shows part.
I have it so you can add shows and delete them. but i cant figure out the whole thing where the shows dont show up if the date has already passed.
say we had a show on the 25th. and its the 26th today. the show on the 25th shouldnt show up.
now for some code.
this is what i have now, but its not working.
<%
set RSshows = Server.CreateObject("ADODB.Recordset")
set showsSQL = "SELECT TOP 4 * FROM events ORDER BY full_date WHERE full_date<=" & Date & ""
RSshows.Open showsSQL, Conn
RSshows.MoveFirst()
%>.
...
<%if RSshows.Recordcount < 0 then%>There are no events currently booked.<%else%>
....else action....
then all the tables to show the shows.
thanks for any help.
-Naaman