i cant filter no transaction in 30 days
for ex. select * from tblmasterlist where re_order_level = '-1', interval (30) "

how?

Few will guess why you can't do this. Supply a minimal viable example.

commented: for ex. select * from tblmasterlist where re_order_level = '-1', interval (30) " +0
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.