DATE MENU problem

bajer

I have a database with entires, and different dates: 0000-00-00
I want to create a menu from my dates that are already in database

Here is example:

2004 - depending if there is entry for that year
2003
2002

once you click on it, it will expand and give you months

2004
- Jan <- This will only show if there is entry(ies) for january
- Mar
- May
2003
2002

Now once I click on 'JAN' it will display me the TITLES of all my heading.
Can I do that from my $date filed (0000-00-00) ??
or do I need to create separate entries in my database?

Thanks

tuf-web_co_uk

to start with you would want to look at either substr(); or explode();

substr(); could be used because all the entries are the same length and would be easy to see if the date 2004-01-28 wasin your database

using something like this

<?
$string = "2004-01-28";

$year = substr($string, 0, 4); // will return 2004
$month = substr($string, 5, 2); // will return 01
$day = substr($string, 8, 2); // will return 28
?>

this can then be used in conjunction with your days

explode(); could be used, using the character "-", which seperates the dates, to split the string

eg.

<?
$string = "2004-01-28";

list($year, $month, $day) = explode("-", $string);

echo $year; // returns 2004
echo $month; // returns 01
echo $day; // returns 28
?>

i'm not sure exactly how this could be used to do what you want it to do but i'm sure, or i hope this will help you get there

bajer

that part I understand, what worries me is sorting...
I need to use function like:

foreach($year) display only 1 year that it finds in records (and sorts it from DESC

then I could do the same for months....

bajer

I have the following dates:
2004 - 03 - 31
2004 - 05 - 31
2004 - 03 - 12
2004 - 01 - 31
2004 - 03 - 31

How can I make them show only once 2004 ??

mrhappiness

with the help of GROUP BY i guess

depends on the structure of your table

bajer

Table has 3 information
$date stored as 2004-01-01
$heading stored as varchar(20)
$body stored as text

I am storing different articles in the database, under different days.
I want to create a menu now, that will be generated based on the $date that I have in database.

so if I have 4 entires with year 2004; I want to display only ones year 2004 and be able to click on that to show under what months are the articles.

Thanks

mrhappiness

you wan tto display each year you have articles created in?
if the colum is of type datetime try

ESLECT DISTINCT YEAR(datecolumn)
FROM tablename

bajer

include '../admin24/config.inc.php';

$ddd = "$y-$m";
if ($m == '05') {
}
$query = "SELECT * FROM diary WHERE date LIKE '$ddd%' ORDER BY date DESC";

$result = mysql_query($query)
	or die ('could not display information');


echo "<a href='index.php?menu=diary&y=2004'>2004</a><BR>";
if ($y == 2004) {

echo "<a href='index.php?menu=diary&y=2004&m=01'>:: January ::</a><BR>";
if ($m == 01) {
while ($row = mysql_fetch_array($result)) { 
    extract($row); 
list($year, $month, $day) = explode("-", $date); 
echo "- <a href='index.php?menu=newdiary&id=$id'>$heading</a> === $year - $month - $day<BR>";
}
}
echo "<a href='index.php?menu=diary&y=2004&m=02'>:: February ::</a><BR>";
if ($m == 02) {
while ($row = mysql_fetch_array($result)) { 
    extract($row); 
list($year, $month, $day) = explode("-", $date); 
echo "- <a href='index.php?menu=newdiary&id=$id'>$heading</a> === $year - $month - $day<BR>";
}
}
echo "<a href='index.php?menu=diary&y=2004&m=03'>:: March ::</a><BR>";
if ($m == 03) {
while ($row = mysql_fetch_array($result)) { 
    extract($row); 
list($year, $month, $day) = explode("-", $date); 
echo "- <a href='index.php?menu=newdiary&id=$id'>$heading</a> === $year - $month - $day<BR>";
}
}

This is what I managed to do so far, but its not automatic, I want to be able to display information automatically. Right now I am saying the year is 2004, but somehow I want to be able to apply this from database, so it find that there is 2004, and starts from that year on....also I want to only display months that it finds entires in......any help would be great, so I don't have to write this huge code....Thanks