Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sales Graph Missing Period Names
11-30-2017, 08:42 AM,
#2
RE: Sales Graph Missing Period Names
You can do it all in one query with the following SQL:

$SQL = "SELECT Year(`lastdate_in_period`) AS year, MONTH(`lastdate_in_period`) AS month FROM `periods` WHERE `periodno`='".$_POST['FromPeriod']."' OR periodno='".$_POST['ToPeriod']."';

Thanks
Tim
Reply


Messages In This Thread
Sales Graph Missing Period Names - by VortecCPI - 11-30-2017, 12:03 AM
RE: Sales Graph Missing Period Names - by falkoner - 11-30-2017, 08:42 AM
RE: Sales Graph Missing Period Names - by TurboPT - 01-08-2018, 03:59 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)