(Firstly, sorry for constantly asking these questions as I can see I'm the last four posters >.> but I'm still newish to coding and the like besides simple debugging)
I have the following Query ready to go for a modification to the bestseller list. I'm trying to use this list to separate the list by groups based on month as an <ul>. But I cannot quite figure out how to do this with a $db->execute($some_query). Anyone mind helping?
Code:
select p.products_id, pd.products_name, p.products_date_available as date_expected,
p.master_categories_id, MONTHNAME(STR_TO_DATE(MONTH(p.products_date_available), '%m')) as month_expected
from jg1_products p, jg1_products_description pd
where p.products_id = pd.products_id
and p.products_status = 1
and pd.language_id = 1
and p.products_date_available >20140721235959
GROUP BY MONTH(p.products_date_available)
Bookmarks