Jump to content

stef686

Members
  • Posts

    5
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

stef686's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. [code]<form id="contactform" name="contactForm" method="post"> [/code] There is no "action" parameter telling the form to go anywhere when submitted to be processed. Simply put in the name of the file that you've shown us into the action parameter: [code]<form id="contactform" name="contactForm" action="contact.php" method="post"> [/code] For example, if the file is called contact.php
  2. [quote]mail($to, $subject, £message)[/quote] "£" instead of "$" That might be something to do with it but I can't check it myself right now I'm afraid
  3. Ah no, sorry, I probably should have explained myself further. What I mean is recording someone actually receiving and opening an email itself, kind of like a read receipt, so in the reports it says something along the lines of "100 of 300 people read the email" I thought maybe a php script in an image tage (<img src="http://www.mysite.com/tracker.php" width="1" height="1" />) could do the trick, but I'm not sure if spam software would see this as some sort of malicious script and block them.
  4. Previously I have been under the impression that this cannot be done, but looking at [URL=http://mailbuild.com/features/reports.aspx]MailBuild[/URL] it seems they have found a way. So, my question - how is this possible?
  5. I have a website with a diary of events. I have just come across this problem: The diary is listed on the site month by month - you can click a month and events for that month will show up. Events have a from date and to date and can span across multiple months. This has all been working fine until I added an event running from december 06 to january 07 - it no longer showed up. Here is how my query looked: (using december 2006 as the selected page as an example) [code]SELECT * FROM diary WHERE (MONTH(from_date) <= MONTH('2006-12-01') AND MONTH(to_date) >= MONTH('2006-12-01') AND YEAR(from_date) = YEAR('2006-12-01')) OR (MONTH(from_date) <= MONTH('2006-12-01') AND MONTH(to_date) >= MONTH('2006-12-01') AND YEAR(to_date) = YEAR('2006-12-01')) ORDER BY from_date, to_date[/code] Now looking back it is obvious that this will not work as it is looking for a match in the years. After some research and trial and error I have come up with the following query: [code]SELECT * FROM diary WHERE (UNIX_TIMESTAMP('2006-12-01') BETWEEN UNIX_TIMESTAMP(from_date) AND UNIX_TIMESTAMP(to_date)) ORDER BY from_date, to_date[/code] However this is still not working. This is really bugging me and any help will be greatly appreciated. Thanks!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.