i need an update to table product_list to happen every 7:00AM and 5PM
i need data from this query
select distinct(a.item_no),sum([url removed, login to view]) from trans_info as a, user_trans as b where a.trans_id=b.trans_id and b.trans_date > date_sub(CURDATE(), INTERVAL 30 DAY) and (b.approve=1 or b.paypal_approve=1 or b.google_approve=1 ) and [url removed, login to view] is null group by a.item_no;
| item_no | sum([url removed, login to view]) |
| 1 | 2 |
| 1030 | 17 |
| 1316 | 7 |
| 1705 | 9 |
to update column 30day in product_list with the sum qty where item_no in product_list = item_no from this query
Bu iş için 23 freelancer ortalamada $34 teklif veriyor
We have just compleated same project like yours requirement. You can check it in review also. Its 2 hour job for us.
Please check PMB for details. Lets start right away.
Hi sir, I can do this. Please check PM for [login to view URL],Chunyou
Dear Sir/Madam: We are group of certified IT professionals ranging from professional Website designers to the Enterprise software solutions architects and developers. Our people have years of industrial experien Daha Fazla
my part in final year project was reporting module. so DB communication is not a big deal