PHP Course Event Monthly View

[FooKelvin]

But the problem is, when I hard code the query with 

WHERE FiscalYear ='FY16'

The table will only show the course name, if there is an event happen in FY16. Meaning it will not show the full list of courses. =(

[Barand]

Don't put FiscalYear condition in the WHERE clause, put it in the table join condition

LEFT JOIN eventtbl e ON c.cid = e.cid AND e.FiscalYear = 'FY16'

[FooKelvin]

oh.. it use me few hours to figure out.

Thanks Barand!

[FooKelvin]

Hi Barand,

 

Sorry for disturbing you.

 

I put in end date to make the table more details.

but the layout seem to be incorrect.

The attachment included 2 start date end 2 end date, but they are like combine it together.

 

 

11/03/15-11/04/15  <- is a complete start and end

11/23/15-11/24/15  <- is a complete start and end

[Barand]

try applying this to your "td" css

white-space: nowrap;

Edited November 13, 2015 by Barand

[FooKelvin]

after i add the css, the date like merging together.

 

 

 

[Barand]

Then you're doing it incorrectly.

 

Post current code.

[FooKelvin]

I added a line end date after the start date.

    if ($sd){
        $data[$cid]['events'][$m][] = date_format(($sd), 'm/d/y'); //m/d/y
    }
    if ($ed){
         $data[$cid]['events'][$m][] = date_format(($ed), 'm/d/y'); //m/d/y
    }

[Barand]

You are adding each date as a separate item. You need to add the date pairs as one item then join the items using "<br>"

if ($sd){
        $item = date_format(($sd), 'm/d/y'); //m/d/y
    }
    if ($ed){
         $item .= '-' . date_format(($ed), 'm/d/y'); //m/d/y
    }
    $data[$cid]['events'][$m][]  = $item;
}

[FooKelvin]

Thanks Barand. I have change the line of code as above. it's working!

if ($sd){
        $item = date_format(($sd), 'm/d/y'); //m/d/y
    }
    if ($ed){
         $item .= '-' . date_format(($ed), 'm/d/y'); //m/d/y
         $data[$cid]['events'][$m][]  = $item;       //<--- Move to this line
    }