Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sales Graph Missing Period Names
11-30-2017, 08:42 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Sales Graph Missing Period Names - falkoner - 11-30-2017 08:42 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)