Your tables aren't setup very well. You should google for
normalization and 'boyce codd normal form'
-Eric
On Sat, 16 Oct 2004 22:27:51 +0200, owca <[EMAIL PROTECTED]> wrote:
> I'm trying get current week, starting from monday to sunday:
>
> select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19,
I'm trying get current week, starting from monday to sunday:
select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20, g21, g22, id
from tydzien where to_days(day) between
to_days(now())- mod(to_days(now()),7)+2 /*some parameter setting a starting
day*/ and
(to_days(now())- mod(to_days(now()),7)