Salvo Posted January 12, 2005 Share Posted January 12, 2005 HI all I have installed the Events calendar http://www.oscommerce.com/community/contributions,1061 it is working very well and it is very useful, but I have the need to add some events for the whole month (30/31 days) ie: from 20 Jan 2005 to 20 Feb 2005. At moment the calendar insert only one day at the time (specifing from to). My question is: Has anyone added the ability to insert from/to and show the event in every date in between? Thanks Salvo Link to comment Share on other sites More sharing options...
Salvo Posted January 18, 2005 Author Share Posted January 18, 2005 Hi all Again I am not quite sure if I made myself undertood, I try to explain it better... When an event is inserted, ie: 01 Feb 05 to 15 Feb 05, the event would show only as 01 Feb 05, not any other day. What I need is the when an evet such as the one above, in the month calendar should show all the days the event dates places. ie: 01 Feb, 02 Feb, 03 Feb etc etc until the last day of the event 15 Feb 2005. I am not sure how to achieve this, maybe the origial Author: Ivan Pascutti could give an hand in this Thank you Salvo Link to comment Share on other sites More sharing options...
Northwind Posted January 19, 2005 Share Posted January 19, 2005 Does it not work to just add another one through its admin module? Hi all Again I am not quite sure if I made myself undertood, I try to explain it better... When an event is inserted, ie: 01 Feb 05 to 15 Feb 05, the event would show only as 01 Feb 05, not any other day. What I need is the when an evet such as the one above, in the month calendar should show all the days the event dates places. ie: 01 Feb, 02 Feb, 03 Feb etc etc until the last day of the event 15 Feb 2005. I am not sure how to achieve this, maybe the origial Author: Ivan Pascutti could give an hand in this Thank you Salvo <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Salvo Posted January 19, 2005 Author Share Posted January 19, 2005 Does it not work to just add another one through its admin module? <{POST_SNAPBACK}> Yes, it does work, but try and post an event from 01 Feb to 15 Feb Fifteen times.... Better post it once From To and have it shown 15 times :rolleyes: Link to comment Share on other sites More sharing options...
zpeedfreak Posted November 28, 2005 Share Posted November 28, 2005 I have the latest version of this contribution and I have an error on my event's page: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-5, 5' at line 1 select *, DAYOFMONTH(start_date) AS event from events_calendar where MONTH(start_date) = '11' and YEAR(start_date) = '' and language_id = '1' order by start_date limit -5, 5 Could anyone help me figure out what's wrong with the SQL syntax. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.