hannibal

Hi, Does anyone know the limit to the number of recipients I should (can) send to using the PHPMailer ADDBCC parameter? (Or event the AddAdress parameter). For example: Select * FROM TABLE Loop results $mailer->AddBCC("email@address.com","name"); End loop $mailer->Send(); Many thanks, H.

Thank you odisian... That is certainly a large step forward. I am sure from the information you have provided will give me enough of a headstart to produce my dynamic SQL Query to show what events are on a certain day, without having the physical record. Something like: Select * from Events Where start_date='2008-07-31' UNION Select *.Events FROM recurring_rules LEFT JOIN Events ON recurring_rules.event_key=Events.event_key WHERE SQLRecurranceConditionMatchesDate. First parts gets appointments which do not have a recurrance for today, and the second call gets the recurring events. Thanks again, H.

Sorry, yes it is still linked (as in related), but does not move when you move the other appointments. (as you may have changed the time to start an hour later on this individual appointment for example). I think the short story is, I am going to have to come up with a simple algorithm with a complex SQL query to find my recurrences as I don't think creating x records is the solution to my issue - although it may suit other peoples solutions. Thanks for your time on this issue. In the meantime, if anyone has any further comments, please post. Thanks again Barand. H.

Correct, you can edit the series "or" this instance. If they were to edit "this instance", then surely Outlook could "create" the instance at this time. Process: -Double click to open "future non-existant" event (i.e. one that outlook has programmatically placed. -User clicks "Edit this instance" -Details are loaded from initially created event (such as detail and start/end time). -When saved, this event is then physically created as a record. It appears seamless to the user, but for Outlook there are now only two physical records. The original record, which has the recurrance pattern, and the "new" record which we have just updated (created behind the scenes). This new record is no longer linked to the recurrence pattern - as it has been changed. Do you follow my method of thinking?

Thanks Barand, but I really wanted to get away from any record creation of the occurences. I may have to do it a long winded way and limit what sort of recurrences the user can have. I just thought that someone would have had experienced a similar issue to mine. It must be able to be done, but it is obviously quite complicated with a very nice algorithm to calc days which the event can be displayed on. Cheers, H.

Thanks obsidian, It is the second option I am after. However, creating this type of algorith is very difficult and I do not know where to begin. I was hoping someone could point me in the right direction or has done something like this before. I can image it is going to be on hell-of-a complicated SQL call, with all sorts of conditions and dateAdd(), etc. Outlook does this task very well, and I am sure MS do not create a record for each occurance. Must be a way, just how!?! Thanks, H.

Revraz, Thanks for your quick reply. This was litterally an example date, it is more of the recurrence feature that I am seeking. The date will more likely stored as YYYY-MM-DD. Thanks, H.

Hi, I have searched the forum & Google to find out where to start with a recurring event calendar, but not having much luck, although there are similar posts with similar request. I do not want to go down the route of creating the recurring events in a separate table. If I created an event on 01/01/1970, and it recurred every Tuesday, how would I query MySQL to show all events for a given day? So, if I looked at next Tuesday, all events for the Tuesday would be listed. SELECT * FROM events_table WHERE event_date='1970-02-16' - This would not show me my event as I do not have this date stored. My start date is 01/01/1970 for example. SELECT * FROM events_table WHERE event_date="Recurs on a Tuesday/or any recurrence pattern (monthly, etc)" - This is the "sort" of thing I am after. It is so difficult to try and create a stable and efficient way of doing this, I don't know where to start at the mo. Any links to recurrence SQL calls much appreciated. Thanks, Hannibal.

roopurt18 - I have just checked and a BCC does not show up as a TO:. The original email recipient displays as the TO:. The BCC is not seen on any email. Hopefully this will clarify to people who do not know this. Looks like the only way to send an email to someone with their name in the TO: box (and no one elses) is to send individual emails. Thanksagain for your suggestions roop. Cheer, Jamie.

Yes, for obvious reasons you would not want to see other peoples email addresses. However, an example is from this site (PHPFreaks), I get an email TO:my email address, I am not BCC'd. So therefore each user must be sent the email individually? Is this not correct? (Off topic - Also, some junk mail filters stop this method of emailing.) Thanks, Jamie.

True. Sorry, what I meant to say was query all subscribed to x post. Then loop through the results emailing to each user individually that a new post has been added. I suppose for larger sites a Cron job really is the only way. Thanks Roop.

Thanks for the advice roopurt. One thing though. I have used PHPBB and other forums on a shared hosting platform which don't support Cron. How do these boards send email notifications out to many people who have subscribed to threads? Surely they must loop through when a new post is added? Thanks, Jamie.

Hi, I need to send a notification email to users when a new post is added. Surely I don't loop through the subscribers when a person adds a post, else that persons page would take ages to complete once their post has been submitted. Is there another way which this can be accomplished? For example, -> Create new post -> Thanks for the new post -> Loop through the MySQL table to see who needs to be notified, then email each person individually. I am sure there must be another way, but unsure of how? Does anyone have any ideas? I though about Cron jobs, but not sure if that suits? Thanks in advance, Jamie.

I will give that a try and post whether it solved my issue. Mega thanks for the instant reply Thorpe! H.

Does anyone have a reply for this as I am in the same boat? Thanks, H.

Hi, I have https://domain.co.uk. If a user logs in and creates a session, when they are forwarded to http://www.domain.co.uk, the session is not accessible (i.e. cannot read what was set). However, https://www.domain.co.uk which forwards to http://www.domain.co.uk allows the session to be read (same domain). Any one know how I can read sessions from a subdomain? Thanks, H.

I have a site where a user can select various multiple items from select boxes to determine their search results. I am using GET as the posting method so that a user can navigate back and forwards with out the "Page Expired" page being displayed and so that they can copy the URL can use it later or send to a friend to see the same search result. This could boviously be quite long, which isn't really too much of a problem. A link may be: www.mysite.com/search.php?location=southwest&location=southeast&car=ford&model=gt&year=1996&year=1997&low_price=2000&high_price=4000 However, I have noticed with sites that use .aspx that they have folders like : www.anothersite.com/location-southwest/car-Ford for example. Another example is www.Autotrader.co.uk. How does copying the folers/directorys reproduce the search? Does anyone have any suggestions how I keep a shorter/tidy url string, or do I simply have to have a mega long string with all my GET parameters? I can't really see a way around it. I am using PHP5 & MySQL 5 (LAMP). Thanks, Hannibal.

Excellent - Works a charm, thank you very much. Doh! Can't believe it was as simple as changing the delimiter. Many many thanks.

Hi I have some code whihc I am trying to exclude several characters: if (!preg_match("/^([a-z0-9._-](\+[a-z0-9])*)", $_POST["code"])){ // Raise error message = FAIL } else { // We are A OK. } In fact, all I want the user to be able to submit are "0-9a-z/_" (i.e. no spances, or dots or other special characters). I want to also esure that the first character is not a "/". But it always fails if I have "/" in my code and I cannot understand why. Any ideas anyone? Thanks in advance. H.

I have: On Update = No Action On Delete = Cascade So that if a customer is deleted, the rest of the non-needed data in other tables is also removed as part of the housekeeping. If a customers record is updated, none of the other tables require any action. This saves me manually looping through other tables and deleting all records if a customer is deleted. There is nothing wrong with this method is there? Seems logical to me... Thanks, J.

Of course. I thought that it was something more sinister! Thanks again for the reply Fenway, you seem to be the man of the moment on here!! On behalf of us all, thank you for a helping hand with your knowledge. J.

Even if On Update = No Action? Thanks, J.

Fenway, What do you mean by thread safe? I am assuming you mean if someone else is executing the same query at the same time, something bad will happen? Thanks, J.

I know that foriegn keys are useful in that if I delete (i.e.) a Customer, all records in tables with his/her foreign key with On Delete (Cascade) will be deleted. Excellent from a maintenance point of view. My question is what overhead on the (database) system is there by having foreign keys? Thanks, J. I am using MySQL V5.

fenway, Do you have an alternative suggestion? Thanks.