--- Tom Phoenix <[EMAIL PROTECTED]> wrote: > On 2/27/07, oryann9 <[EMAIL PROTECTED]> wrote: > > > Problem: cgi calender daynames are not matching up > > with dates. For example: Todays date 02/27/2007 is > > being printed under Thursday instead of Tuesday. > > Is the problem that you need to determine the day of > the week for a > given date, or that you need to get something to > line up vertically > with something else? > > From looking briefly at your code, you seem to be > using SQL to > manipulate dates and times. In Perl, it's generally > easier to use a > module to do that. (Unless, of course, using SQL is > part of the > homework assignment.) > > --Tom Phoenix > Stonehenge Perl Training >
Tom, thank you for replying. Well I solved the first issue, determining the day of week for a given date using select dayofweek(curdate()), so yes I am having issues lining these days line up with dates b/c as the days move forward the foreach $day ('-15' .. '15') loop alters the table. This is a homework assignment for an online SQL class I am taking through O'reilly for continuing education even though I work as a Unix Engineer. ____________________________________________________________________________________ Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/