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]

Reply via email to