retired_musiclova31

Trying to only show news items posted in the last 14 days. got no idea why it's not working - no data returned despite there being two rows in the dataset that qualify...

<pre class="ip-ubbcode-code-pre">SELECT news_title, news_body, news_datestamp, phpbb3_users.username AS news_author_name, news_authorFROM tq_news, phpbb3_usersWHERE phpbb3_users.user_id = tq_news.news_author AND DATEDIFF(NOW( ), news_datestamp) &lt; 14ORDER BY news_id DESC</pre>

any ideas?

retired_gulkis

DATEDIFF is always a bit of a **** for me. what happens if you use TO_DAYS(...) - TO_DAYS(..) in place of it? at least to localise the problem.

retired_jerilyn

Should avoid using DateDiff where possible, it's heavy on the processing.

Could you use:

...AND news_datestamp &gt;= getdate()-14

?

retired_musiclova31

how would i structure that?

never used it before.

retired_musiclova31

that's not valid syntax eddy

retired_bigsean999

move the equals back one place!

retired_jerilyn

That'll be because its MySQL, missed that....

Does

WHERE DATE_SUB(CURDATE(),INTERVAL 14 DAY) &lt;= news_datestamp

work?

retired_gulkis

(TO_DAYS(NOW()) - TO_DAYS(news_datestamp)) &lt; 14

just instead of the DATEDIFF bit. a bit of googling says DATEDIFF is apparently a bit dodgy until version 4.1.15.

retired_musiclova31

using tim's to_days... still showing no data

changed the 14 to 1000 and still says no data. there is definitely data in the db.

retired_musiclova31

no. invalid syntax apparently