hmm, i dont know which db server that u use, but in mysql there's a function week(date) WEEK(date[,mode])
The function returns the week number for date. The two-argument form of WEEK() allows you to specify whether the week starts on Sunday or Monday and whether the return value should be in the range from 0 to 53 or from 1 to 53. that was taken from mysql manual, if you know the week number of a date, then u can use mod to know in which page that week transaction will show up. do u find this helpful? --- In php-list@yahoogroups.com, Bob Sawyer <[EMAIL PROTECTED]> wrote: > I'm sure there's a pretty simple way of doing this but I've been > wracking my brain with it for too long now. Time for professional help! > :-) > > I have a client who wants a an online production schedule. The page > needs to display eight weeks at the time, starting with the current > week. Naturally, links to previous eight week period and next eight > week period are desired. > > Under each week's column will be production order numbers, etc. that > are pulled from the database, as well as ship dates and so forth for > older orders. > > SO - I'm having a hard time getting the weeks thing worked out. I would > rather NOT take an existing calendar script and try to tweak it, but if > anyone has a simple, easy-to-follow example similar to what I'm talking > about, I'd appreciate being able to look under the hood to see if I can > figure out what to do (and what NOT to do.) > > Thanks, > -Bob > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com Community email addresses: Post message: php-list@yahoogroups.com Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
