Quirky Coding Help Needed

OK thanks Chan. I have a new problem that I need help with. I have changed my infusion table field from 'posted' int(10) TO 'post_date' date not null default='0000-00-00' and there is so much confusing information when I do google searches on date/time functions. With my column being only 'date' (no time needed or wanted), I cannot insert a record. I have tried many different scenarios to do this. How can I insert the current date in this field at post creation time? 'yyyy-mm-dd' format.

Sorry nevermind. I got it figured out. $post_date = date("Y-m-d");

Im sorry got busy with sorting out work for this site. I would like to post my share of input.

​I see that the column has day and month. To query multi column is slower than to query on 1 single column. I prefer the datestamp int(10) method. This would have been easier with this query to sort month and day using php. 

​​​​​​Insert to blog item using php timestamp. aka time(). To fetch the items would be easy with these:

// February 2020
WHERE MONTH(FROM_UNIXTIME(blog_timestamp)) = 2 AND YEAR(FROM_UNIXTIME(blog_timestamp)) = 2020

i would also add selector in SQL to give me the month and the year as well to sort into query output. 

SELECT * , MONTH(FROM_UNIXTIME(blog_timestamp)) as month, YEAR( FROM_UNIXTIME(blog_timestamp)) as year

So dbarray($res)) will have month and year in your dump. To sort into array I would do this:

$data['link'] = BASEDIR."....?id=$id";

$cache[ $year ][ $month ][ $id ] = $data;

​To callback items on your cached data.. 

Say month 2, Year 2020. will be

$feb =$cache[2020][2];

it will give u 2 dimension array you can loop like this

foreach ($feb as $id => $data) {
 print_p($data);
}

You can also use SQL to add selector DAY(FROM_UNIXTIME( datestamp )) as day, if you need it.

I did not include isset check or empty check in my code above. You can freely add them if needed.

That is how I would design dated stuffs with main priority in sortable and filter control at SQL level. PHP end is just mostly decorative adds and parser for best practise. I will not filter results using php.. proven very slow to render. 

This is the most bizzare thing I have ever seen. I can generate the complete code but no matter where I put it in the calendar script it won't work. This is an image of my test file's output:
 

It's the same but with an added array for the "link". What it boils down to I think, is a 4 dimensional array. I have no experience with multi-dimensional arrays. Consequently I have absolutely no idea how to solve this.
 

When I do that in the calendar script itself this is what I get:

However I get this printed to the screen above the calendar proper for a VERY VERY LONG time: I assume for each day of the month:

 

Well I think my brilliant idea is just not going to work. No matter what I do and no matter how I configure this thing it won't work. The
in the script screws everything up. When I try to include the "query coding" within that array it will not work. I really appreciate your attempts at helping me douwe. It does generate the right stuff I just can't incorporate it in the original script so I suppose I'm going to abandon my pursuit.[/code]

Maybe something like this (sorry adding as code is not working for me atm):



You can check the contents of the array by adding statement var_dump($na) as test after the loop.



 [/code]