/    Sign up×
Community /Pin to ProfileBookmark

Creating A PHP Calander/List/Calander List

Copy linkTweet thisAlerts:
Apr 03.2006

Hi Folks

Could someone help me out here
We have this [url]http://www.loddonexplorers.co.uk/program.html[/url]

How can i make this into PHP and SQL?
I.E It would have the dates, when we type in the date of the event it adds it to that month, possibly color codes it…

Any help would be appreciated, looks like a mini project for me!

Thanks Very Much!
Fet

to post a comment
PHP

1 Comments(s) ↴

Copy linkTweet thisAlerts:
@sitehatcheryApr 09.2006 — Tables:

Note: underlines show primary IDs and italics show foreign keys.

Year_Term([U]year[/U], [U]term[/U])

note: term would include months, easter holiday, summer term, etc.

Type([U]type_id[/U], name, description, color)

Event([U]event_id[/U], date, time, event, place, [I]type_id[/I])

Leader([U]leader_id[/U], name)

Leader_event([I]event_id[/I], [I]leader_id[/I])

Executing:

ORDER BY year, term, date

display term and year only once in your iteration

So, there's a quick analysis of your spreadsheet and a possible way you could set up your database.
×

Success!

Help @scottyrob spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.15,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...