I have a query that simply fetch data from my database, this query returns 590 rows.
When I put the SAME query, untouched in PHPmyAdmin, it returns overs 1000 records.

I have tried to write the query in other ways, changed from mysql to mysqli, the result is the same. I can't get all the record that I need.

`SELECT invoice_orders.invoice_number, invoice_orders.ddt_number, invoice_orders.date, invoice_order_products.productcode, invoice_order_products.category, invoice_order_products.amount, invoice_order_products.price, invoice_order_products.composizione`

`FROM invoice_orders, invoice_order_products`

`WHERE invoice_orders.id = invoice_order_products.invoice_id
AND FROM_UNIXTIME( invoice_orders.date, '%m/%Y' ) = '01/2011'`

thanks