[SOLVED] Not sure how to title this

[timmah1]

I grab information from the database that matches the current month, then I put the days into an array like so

$days[] = date("d", strtotime($charts['posted']));

 

Then I implode them to make put marks on a graph

$day = implode(',', $days);

 

Works great.

 

But what I want to know is, how can I find out what the first day in the database is?

Right now, the database has the days 11 through 29, but I need the code to be able to only show the first number, which would be 11 in this case, then I'll do some math stuff to fill in the gaps on the graph.

 

So basically what I need to know is, with the following code

$days[] = date("d", strtotime($charts['posted']));
$day = implode(',', $days);

 

How do I find out the first number?

 

Thanks in advance

[gaza165]

so really what you are looking for is the lowest number (day) in your array of dates??

[timmah1]

Correct.

I need the code to stay the way it is, but I want to be able to find the lowest number, so I can do some other things with that, and I'm not sure who to do it

[xangelo]

The easiest way would be to do this:

 

$days[] = date("d", strtotime($charts['posted']));
sort($days); 
$day = implode(',', $days);

 

sort()

[gaza165]

why dont you use the min() to get the lowest number of the days

 

$days[] = date("d", strtotime($charts['posted']));
$first_date = min($days);
$day = implode(',', $days);

[gevans]

You want to look at sort()

 

<?php
$days[] = date("d", strtotime($charts['posted']));
sort($days, SORT_NUMERIC);
$day = implode(',', $days);

[timmah1]

Exactly gaza165!

 

Thank you so much!!