Addressed to: Mattias Hedman <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from Mattias Hedman <[EMAIL PROTECTED]> Thu, 12 Oct 2000 09:43:09
+0200
>
> Hello all! I have a problem... I need to fetch data out of a mySQL
> database. The Data should be between 2 specific dates. No trouble so far.
> But my problem is that I need to calculate the start and end date with
> only the week number to my knowledge. Anyone got any ideas?
MySQL includes a week() function. If your week numbers match up, or can be
made to match up easily, you might do something like:
SELECT * FROM table WHERE WEEK( some_date ) = $WeekNumber
See:
http://www.mysql.com/documentation/mysql/commented/manual.php?section=Date_and_time_functions
Rick Widmer
Internet Marketing Specialists
www.developersdesk.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
