itouch calendar

[davidjmorin]

does anyone know what calendar the itouch uses and if there is a web based version of it? i like the way it opperates and displays the events on the given day./ any ideas?

[PeejAvery]

Do you mean iPod touch? If so, Calendar is a Mac OS native app. There is nothing even close to it web-based wise.

However, calendars are some of the easiest things to program. There are also tons of PHP calendar examples (http://www.google.com/search?source=ig&hl=en&rlz=&q=php+calendar+script&btnG=Google+Search) out there.

[davidjmorin]

man i have got to tell you i have tried many to no avail. im kinda picky too.
i want one that shows the week were in and shows events for the day were in under that but have the following days linkable to show events for that day. does that make sence.
example is here chicago.metromix.com/
thats exactly what i want

[PeejAvery]

That calendar is only 7 days listed across. When you click on one, then you just query the database for any item matching that date.

1. Create a table on a database named "events" with at least the fields id, date, time, and description. Below is a SQL command to create such a table

CREATE TABLE `events` (
`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`date` DATE NOT NULL,
`time` TIME NOT NULL,
`description` TEXT NOT NULL
);

2. When a person clicks on a day, you just query the database for all events on that day.

$query = mysql_query("SELECT * FROM `events` WHERE `date` = '2008-01-24'");
while($row = mysql_fetch_assoc($query)){
echo $description;
}

[davidjmorin]

how do i get the date to auto populate the day that were in?

could you show me a real simple short code that would work? and then ill run from there.

[PeejAvery]

how do i get the date to auto populate the day that were in?
I just gave you that. Look at the second example.

[davidjmorin]

so that will give me each new day?

[PeejAvery]

What are you talking about? I thought you meant a selected
days activities.