I can run the same SQL code in Phpmyadmin and it works showing the database requested, using PHP reports it just sits there
SELECT DISTINCT ost_ticket.number, ost_ticket__cdata.lancom, ost_user.name, ost_ticket.created, ost_ticket.closed, ost_ticket_status.name, ost_help_topic.topic, ost_ticket__cdata.subject FROM ost_ticket JOIN ost_staff ON ost_staff.staff_id = ost_ticket.staff_id JOIN ost_user_email ON ost_ticket.user_id = ost_user_email.user_id JOIN ost_user ON ost_user_email.id = ost_user.id JOIN ost_ticket_status ON ost_ticket.status_id = ost_ticket_status.id JOIN ost_ticket__cdata ON ost_ticket.ticket_id = ost_ticket__cdata.ticket_id INNER JOIN ost_help_topic ON ost_ticket.topic_id = ost_help_topic.topic_id WHERE ost_help_topic.topic = 'IPFX Hell' and ost_ticket__cdata.lancom BETWEEN 2000000 and 3000000 and ost_ticket.created >= '2022-03-08' ORDER BY ost_ticket.created ASC;
I can run the same SQL code in Phpmyadmin and it works showing the database requested, using PHP reports it just sits there
SELECT DISTINCT ost_ticket.number, ost_ticket__cdata.lancom, ost_user.name, ost_ticket.created, ost_ticket.closed, ost_ticket_status.name, ost_help_topic.topic, ost_ticket__cdata.subject FROM ost_ticket JOIN ost_staff ON ost_staff.staff_id = ost_ticket.staff_id JOIN ost_user_email ON ost_ticket.user_id = ost_user_email.user_id JOIN ost_user ON ost_user_email.id = ost_user.id JOIN ost_ticket_status ON ost_ticket.status_id = ost_ticket_status.id JOIN ost_ticket__cdata ON ost_ticket.ticket_id = ost_ticket__cdata.ticket_id INNER JOIN ost_help_topic ON ost_ticket.topic_id = ost_help_topic.topic_id WHERE ost_help_topic.topic = 'IPFX Hell' and ost_ticket__cdata.lancom BETWEEN 2000000 and 3000000 and ost_ticket.created >= '2022-03-08' ORDER BY ost_ticket.created ASC;