event calendar

[techker]

hey guys i have an event calendar script that insert in a databse the event like so:

 

  id  uid  m  d  y  start_time  end_time  title  text 

 

now i want to do some stats on my maine page.

 

like upcomming event,# of evevent in the week and month..

 

so my questions i got the day

 

SELECT `d` 
FROM pec_mssgs
WHERE `d` >= day( curdate( ) ) 
LIMIT 0 , 30 

how can i select the week?

[rhodesa]

why so many fields? just use a field type of DATETIME and put the whole thing in there:

 

start = '2008-12-29 08:00:00'

end = '2008-12-29 09:00:00'

 

then you can use BETWEEN to get events between certain days