using database date

Hi Guys

On a blog, at the moment I have created a content area within the template for the user to add the blog date.

If I wanted to automate that and use the date for that a specific entry within the database itself, how would i go about it please?

Thanks

Jami

set the default value for the date column to NOW()

this will cause the current date to be entered by default when a new record is created.

thanks

Jamie

Hey guys

Had a really good and informative premier support last night with Ray - thanks for that and all the info!

I have taken what Ray and I did last night and am trying to translate it over to another website.

I seem to have hit a bit of a wall in that the date that is being returned from the database is showing the most recent date for all 3 posts rather than the date that each one should have.

As you can see from the attached image (dates.jpg) there are 3 different dates in the database for the 3 different posts.

But in the screen shot of the list on the front end, although the titles are listed fine, the dates are only showing the date from the most recent post.

I have spent ages trying to trouble shoot this and fix this but am really struggling... I just dont know what I should be looking for to effect a fix and would really appreciate a steer.

Many thanks

Jamie

Hi, wouldnt that attached image suggest you have your repeat region code slightly off on your page? since its not moving the repeat counter for the date part of your code. have you exmained the repeat region area on your page? perhaps its just the slightly line placement thats causing your issue?

Chris

thanks for the reply Chris, am not really too sure to be honest. This is the area including the repeat region:

<?php do { ?>
    <div id="newsList">
      <div id="newsDate">
        <?php
include('WA_CMS/addtosite.php');
echo(date("d M Y",strtotime($row_LatestNewsRS['ContentDate']))); 
?>
        </div>
      <div id="newsTitle"> <a href="news-item.php?zzLatestNews=<?php echo $row_LatestNewsRS['ContentPageSetOrder']; ?>"">
        <?php
include('WA_CMS/addtosite.php');
echo str_replace(array("<p>","</p>"),"",WA_getCMSContent($database_PowerCMSConnection, $PowerCMSConnection, 'zzLatestNews', 'Title', false, $row_LatestNewsRS['ContentPageSetOrder'],80));
?>
        </a></div>
    </div>
    <?php } while ($row_LatestNewsRS = mysql_fetch_assoc($LatestNewsRS)); ?>

if you have any thoughts as to what I am doing wrong would really appreciat it!

Thanks

Jamie

Hi well I'm no expert yet but wouldnt it have something to do with having those 2 includes inside the loop? They are not include_once so that may cause problems depending what's contained in those includes. Have you tried putting them outside the loop?

send a copy of your page please so i can see the code in context.

also a copy of the page ray worked on originally.

Thanks Chris and Jason, I think I have fixed that problem (not 100% sure how though tbh!).

Have come up against a couple of other problems with it though.

Basically if you go to latest-news.php all 4 posts are visible with the correct date.

If you go to any of the results pages, then the date shown is always the most recent post regardless of whether you are viewing post 1 2 3 or 4....

Thats problem 1 and I know its something to do with the results page but cant figure out what or why

The second problem is that when you click on either of the news archive links in the top right panel you go through to the relevant months posts, but then when you go back to the main listing page (ie latest-news.php) it only shows the posts from the month that you looked at in archive....

If you need any of the code, just let me know which ones......

Thanks in advance for any and all help

Jamie

I'll need these three pages to look into the problem.

news-archive.php
news-item.php
latest-news.php