PHP/MYSQL - date sorting in table my months

Hi

I have a quetion about mysql.

In my mysql table field date as format 2011-06-20.

I need some help to get it into a html table splitted in every month like:



So I got the oppotinity to make a header over each month called JANUAR 2011 and so on.

Anyone who knows how to do this.

/jokerper

You can use the MONTH() function to group up each post by month.

Thanks would it say that I have to make the select 12 times like this:

SELECT * FROM table WHERE MONTH(date_field) = 1
SELECT * FROM table WHERE MONTH(date_field) = 2
SELECT * FROM table WHERE MONTH(date_field) = 3
and so on...

Or howto make it like this:
A Headline January
echo "<td>".$row['']."</td>";
echo "<td>".$row['']."</td></tr>";

<break>When all from January are printed

A Headline February
echo "<td>".$row['']."</td>";
echo "<td>".$row['']."</td></tr>";

<break>When all from February are printed

and so on...

It would be nice if you give a sample of that database info to help create a working sample...

Okay there it come:



I hope this is what you asking for.

Is there any further help to get for my problem.

Here is one suggestion (using two queries):



Only tested it on a minor database so I'm not sure of the efficiency of it. = P

Thanks you, can you please tell me how to replace the name of the months to Danish.

like
June = Juni
july = Juli

ect.

This may or may not work depending on the server:



The new/changed lines are setlocale(LC_ALL, "danish"); that was added and $month that now looks like this:


%B basically says "return the month name in letters" and setlocale tells it to do so in Danish (I hope).

strtotime is needed there or you will get a error about bad value bla bla bla.

That is working, thanks - I love when things just works!!!

You're doing a good coding... Simple

Thank you, again.

Good thing it worked, my code don't look like that usually/always but that's a different story. = )

Sidenotes,

using curly brackets might clean the code even further. i.e.


vs. with curly tricks (php5 {$array{}} <php5 {$array[]})..



When parsing the sql resultset you might want to use mysql_fetch_assoc($r) instead of mysql_fetch_array($r). Difference is that mysql_fetch_array will also return column numbers as available arraykeys next to the associated ones that are used in the script.

i.e.
$row{0} = 'value', $row{id} = 'value', $row{1} = 'value1', $row{'Title'} = 'value1'

This might reduce memory consumption dramatically with big applications.

Just for your consideration..

Interesting, this is new syntax for me. Does it affect performance and is there a place where I can read about this further?

the curly wrapper is pretty old, as I can remember using it in PHP4.

I read about the curly brackets in arrays in some book. It was suggested to be the PHP5 method of accessing array indexes. And as fas as I know it works, not sure if it will be finally adopted or if it will actually enhances performance for there is not much about it in the php manuals. But the following can be found on the subject using the following page in the php manual. http://www.php.net/manual/en/language.types.string.php

about the array index
Characters within strings may be accessed and modified by specifying the zero-based offset of the desired character after the string using square array brackets, as in $str[42]. Think of a string as an array of characters for this purpose. The functions substr() and substr_replace() can be used when you want to extract or replace more than 1 character.
Note: Strings may also be accessed using braces, as in $str{42}, for the same purpose.

About curly..



Using the correct mysql resultset parser will surly improve memory usage, simply because you are generating and popping less information into your arrays.

Using the curly wrapper instead of escapes is part of the PHP complex syntax.

Rgrds, Chris