Solved

Show recent records on news page and older records on archive page

Posted on 2008-10-03
3
167 Views
Last Modified: 2010-04-25
Hi,

I have a 'news page' with the most recent (say this months') records listed. I need to create an 'archive page' with the continuation of those records listed (after this months').

This link shows example:-
http://www.whrproperty.co.uk/articles.asp?pagekey=116
(link to 'archive' at the bottom of the page)

This is my actual page:-
http://www.propertyalliancegroup.com/new_site/news.php
0
Comment
Question by:kaz0161
3 Comments
 
LVL 8

Expert Comment

by:jtdebeer
ID: 22638239
Copy your page news.php and name it archiveNews.php,

Now change both your database queries to include a date filter. ie

Select * from News where date > (Select getdate()-30)) on the News.php page
and
Select * from News where date <= (Select getdate()-30))

That is if you have a date coloumn on your table.


Have fun
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 22638244
Hi kaz0161,

You would need to store all news entries in a mysql table and use PHP and mysql queries to pull them out as desired.  

What exactly is your question?
0
 

Accepted Solution

by:
kaz0161 earned 0 total points
ID: 22638406
I have a mysql table which is called 'property', 'date' is my column and it is all populated. I am using dreamweaver but am struggling with how to use php and mysql queries to get one page of recent records and one page of the continued older records.

A friend suggested this:-

$newstime = mktime(0, 0, 0, date("m")-2, date("d"),   date("Y")); // Change the 2 to the number of months ago you want
$query_rs_Images = "SELECT id, filename, heading, `description` FROM news WHERE date > ".$newstime." ORDER BY date DESC";

I shall try your suggestion jtdebeer (yours seems less complicated) and will get back to you tommorrow when im in work. Hopefully all will be well.

Thankyou.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now