AFreeBreather
-
Posts
3 -
Joined
-
Last visited
Posts posted by AFreeBreather
-
-
CSV is the format they're given to me in - as far as how they're being stored my table is organized like this: Date,Time,Caller ID,Originating Number,Number Called,Length,Comments
-
Hey all I'm new here - this is my first post.
I've been tasked by my boss' boss to design a dashboard for our company. The development is coming along reasonably well so far, considering I've got minimal PHP and mysql experience, but I've hit a road block this rainy afternoon and request the help of the php freaks community. Here's a look at the data I've got: (it's all in csv format)
19-Dec,5:12 AM,EW SCRIPPS ,561-718-5959,200,0:02:00,Incoming call forward
19-Dec,4:54 AM,EW SCRIPPS ,561-718-5959,200,0:14:57,Incoming call forward
15-Dec,3:37 PM,CHANNEL 9 AUSTR ,213-709-4290,200,0:02:34,Incoming call forward
15-Dec,8:02 AM,Unavailable ,97440158274,200,0:01:14,Incoming call forward
I want to pull the dates from the database, trim off the day, stick the months that exist into an array, array_unique() that array, and foreach the new array so that it spits out a nice html check box for every month that exists in the database. I've got no code for this, yet, and I'm not even sure of where to begin. What's the best way to trim off the day from the dates? Is putting it in an array the best method?
I know I'm guilty of the #1 forum sin (I didn't use the search function) so if anyone knows of a previous forum post like this point it my way.
Thanks so much for your help!
First Post
in Application Design
Posted
i'm splitting them up into different columns in the same table.