retired_musiclova31

no diff. still invalid.

retired_gulkis

is the first clause definitely legit? my SQL is a bit shaky but shouldn't you be doing an INNER JOIN somewhere? or does it just join them implicitly?

retired_musiclova31

without the date clause, the query works just fine. i WAS working with an inner join at first, but didn't need it.

just checked on phpMyAdmin - the field is a 10 character INT rather than an actual date/time stamp field in the db: that shouldn't matter should it? i mean it's still a ten digit date that is stored...

retired_gulkis

how do you mean? so 10042007 would be representing 10/04/2007. it could be a bit dodgy because i reckon dates would be internally represented using integers too (and no doubt in a different way).

retired_musiclova31

no, it's a proper mysql datestamp - 1148331647 = june 7th for example.

dejasade

i thought to process the date you need to put (dd MMM yyyy) so the numbers are seperated properly.
it doesn't recognise 10042007 in VB.net anyway.

retired_musiclova31

when i call the data from the db, not trying to use 14 day clause, but using the rest of the query in my first post, and then in my php document put this:

<pre class="ip-ubbcode-code-pre">&lt;p&gt;Posted by &lt;a href="http://forums.thequadrant.org/memberlist.php?mode=viewprofile&u=&lt;?php echo $row_rs_tq_news['news_author']; ?&gt;"&gt;&lt;?php echo $row_rs_tq_news['news_author_name']; ?&gt;&lt;/a&gt; on &lt;?php echo date('l F dS, Y \a\\t h:ia',$row_rs_tq_news['news_datestamp']); ?&gt;&lt;/p&gt;</pre>

i get:

Posted by Scatter on Thursday June 07th, 2007 at 07:14am

retired_musiclova31

gah. clever

retired_musiclova31

got it working - it was the field type in the db. once i changed it to a timestamp it worked...