date() function, strange question...

kurky

Hi, not sure if I should be posting this in the newbies forum as it seems very complicated, but then again I'm a newbie so I guess it would be complicated.

What I want to be able to do is show some articles on a set day, and then show links to the last six days.

ie:

Today Thursday (05/12/2002)
Todays news... blah blah blah

see news from weds,tues,mon,sun,sat,fri... these will each have a separate link going to a page which will show the news from that specific day. Note that I want to show the days and not the dates, therefore yesterday is wednesday, but tomorrow I would like yesterday to be Thursday? I've probably lost you nowbut it's quite hard to explain!

No one at my work experience place can help me with this, although they told me to look at this:

<? function datefr($MyDate, $WeekDayOn=1, $YearOn=0) {
$MyMonths = array("Janvier", "Février", "Mars", "Avril", "Mai", "Juin", "Juillet", "Août", "Septembre", "Octobre", "Novembre", "Décembre");
$MyDays = array("Dimanche", "Lundi", "Mardi", "Mercredi", "Jeudi", "Vendredi", "Samedi");

$DF = explode('-',$MyDate); 
$TheDay = getdate(mktime(0,0,0,$DF[1],$DF[2],$DF[0])); 

$MyDate = $DF[2]." ".$MyMonths[$DF[1]-1]; 
if ($WeekDayOn) $MyDate=$MyDays[$TheDay["wday"]]." ".$MyDate;
if ($YearOn) $MyDate.=" ".$DF[0];

return $MyDate;

}

If anyone has an idea as to what the function does, can explain it, suggest how I should use it to do what I want to do or even suggest a good article which is easy for beginners to understand then I would be really grateful. I've tried reading up on the date function etc and have spent all day doing that but it just all seems like a foreign language to me! Any help would be much appreciated.

Sharon[/code]

Wien

Would you tell us how your data are stored in your database because the solution will depend on it.
What you want to do doesnt seem that difficult. You know in PHP you can get the current date, then if your news are correctly stored (with date field) in your DB you can fetch (SQL query) all today's news, and also yesterday's news... Well, tell me about your DB and I'll give you more advice.

kurky

Hi,

I have the date stored in the db in the date format: 2002-10-01 (just a date as an example). Do you need to know how the rest of my date is stored, or is it just the date that it is important?

If I haven't stored the date in the correct format or if it's going to be a problem, please tell me as I can still correct this as my db isn't very big and it wouldn't take long to change.

Thanks

Sharon

Wien

Well, it's fine if your dates are stored in the DATE format, it will makes things easier.

So what I can show you for example is how to fetch all the news posted today :

SELECT FieldsYouWant FROM News WHERE Date = CURDATE();

very easy isn't it

All the news posted yesterday :

SELECT FieldsYouWant FROM News WHERE Date = DATE_SUB(CURDATE(), INTERVAL 1 DAY);

with DATE_SUB(CURDATE(), INTERVAL 1 DAY) => today's date - 1 day

Let's say now you want to fetch the new from todays and the last 6 days, and all this order by date of course

SELECT FieldsYouWant FROM News WHERE Date <= CURDATE() AND Date >= DATE_SUB(CURDATE(), INTERVAL 6 DAY) ORDER BY Date;

Hum, so easy

To understand more see time and date SQL functionshttp://www.mysql.com/doc/en/Date_and_time_functions.html

Well now you need to display evrything, and i suppose you know how to fetch results of a query, but about the dates you will have to know for a given date (let's say 2002-12-04) what the day is and for that you'll need PHP functions and I'm starting lazy so have a look at this link
http://www.php.net/manual/en/function.date.php

and don,'t forget to read tutorials on this site because they are very good.

Hope it will help you
If you're still lost, post again we'll be here
bye