[PHP-DB] Re Subject: SQL WHERE datetime NOW

2004-01-03 Thread Neil Smth
Presumably where you are generating TO_DAYS(NOW()) you meant to say TO_DAYS(NOW())+1 ? (which is days *after* today !) Also, you did not specify how it does not work - can you be mroe descriptive, what error message did you receive, how many rows did you expect and get out ? Cheers - Neil.

[PHP-DB] re: handling newsletter bounced emails. :)

2004-01-03 Thread JeRRy
- HI there everyone, Is it possible to use PHP to check an email on the same server? I have a system setup for my newsletters which I want to expand, and basically when mails bounce back to a certain email address on the server as failed it would then read the email and remove the

[PHP-DB] Re: Subject: grabbing text from a webpage and putting it in a query.

2004-01-03 Thread JeRRy
All I can suggest is that you cut and paste the desired text into notepad and save it as a file. This is because their pages are not regular nor xhtml (or even well formed HTML) that you cannot parse the page reliably. So, cut and paste the text only and save it first using notepad,

[PHP-DB] SQL WHERE datetime NOW

2004-01-03 Thread John Dillon
Thanks for that. In fact, it was something else wrong and it does work. However, I do have another problem on this. The query is: ...WHERE TO_DAYS(NOW())+1TO_DAYS(MyTable.MyField) ORDER BY MyTable.MyField DESC LIMIT 30; however, the LIMIT seems to apply before the ORDER BY clause. How can