[RESOLVED] Calendar Table

thekidscareya

I need some advice on how to build a simple calendar table.

All I need is the following fields:
-id (primary key)
-date
-time
-subject
-html
-posted_by

I just want to query for the latest 3 upcoming events and be able to add/edit/delete events using PHP. Is this table structure the best bet to go? Should I break it down (eg: instead of date have month, day, and year?)? I want to keep the number of columns as limited as possible because it would be easier for me to code.

shamly

try using timestamp to maintain the date and time ... it will make the search query much simpler...

thekidscareya

shamly wrote:
try using timestamp to maintain the date and time ... it will make the search query much simpler...

How would write a select query that would get the last 3 events? Also, how would I write an insert query...with a form...would the form have two fields - date and time - or will it just have that one field?

Thanks

shamly

timestamp is a long integer containing the number of seconds between the Unix Epoch (January 1 1970 00:00:00 GMT) and the time specified. A timestamp will look like this ... 1122968297.

so the sql query will be like ...
select * from table where column between $time1 and $time2;

You will have to have 2 fields in the form .. and you need to calculate the imestamp from that ... it easy.