display variable(changing) text on my webpage

[royjacob]

i want to be able to display changing text on my page. for instance, if its monday, i open a database, fetch the relevant record(in this case a long text message) and display it on my web page. if tuesday, another record and so on...

any ideas, help appreciated!

 

[palbano]

There are quite a few FAQs on database access and displaying data from recordsets. Check them out and then post back if you have specific questions. Also take a look at the general FAQs about how to ask good questions.


-pete

 

[snowboardr]

Database Setup:

http://www.vzio.com/tutorials/mysql_database.asp

ASP/SQL Statement:

To display the weekday numbers you can use this script, it will show you what WeekDay numbers represent:

<%
Response.Write &quot;Today's Day is: &quot; & Date & &quot;<br><br>&quot;
Response.Write &quot;Today's Day of the week number is: &quot; & WeekDay(Date) & &quot;<br><br>&quot;
Response.Write &quot;Today's Day of the week is: &quot; & WeekDayName(WeekDay(Date)) & &quot;<br><br>&quot;
Response.Write &quot;The year is: &quot; & year(date) & &quot;<br><br>&quot;
Response.Write &quot;The time on this server is: &quot; & time & &quot;<br><br>&quot;


For i = 1 to 7

Response.Write WeekDay(&quot;9/&quot; & i & &quot;/03&quot;) & &quot; &quot; & WeekDayName(i) & &quot;<br>&quot;

Next
%>

Then after you install mysql, and READ how you connect to the db in that tutorial, then you can just use this sql statement:

strSQL = "SELECT WeekDay,WeekDayText FROM table_name WHERE WeekDay=" & WeekDay(Date)

Make sure WeekDay is a numeric field, if its not then you will have to put single quotes around it.

- Good luck.
Jason



www.vzio.com
ASP WEB DEVELOPMENT