I need help with my news script please!

Anon

Ok I want to make a news script, this is what I have in mind.

I'll make the entries go into a database which also has a date field, then when I wanna display them i'll sort by the date and display 7 (for the week).

The problem is, how do I make all old news expire?

I was thinking to just subtract 7 from the current date and then use the "WHERE" parameter for mysql and delete anything from 7 days ago, but what if the date is January 4th, 2001. You can't subtract 4 from 7. Is there a way I can get the date properly from 7 days ago? or does anyone know a better way of going about making the news script?

finger

dont know the syntax, but most databases
support "data-calculating" ... so if you
have 2000-04-01 and substract 5, you'll
get 1999-31-12

regards

finger

harris97

I think you can learn by downloading free PHP news script at http://www.hotscripts.com

[deleted]

Ofcourse you can still subctract 7 days from Jan 4th 2001.

in MySQL:
where date_field>date_sub(now(),interval 7 day)

Anon

Is date_sub a function of MySQL or PHP? just wondering becuase I was thinking of buying a PHP book so I could learn some more conditional statements becuase i've never seen date_sub.

Anon

Woops i meant MySQL book.

[deleted]

Date_sub is a MySQL function.

all the commands and options to both PHP and MYSQL are mentioned and explained in their respective manuals...