Re: [PHP] Speeding up a Mysql Select

You should include a LIMIT to the sql-query or mysql parses the whole database example: SELECT * FROM `support` WHERE `begintime` 'timestamp1' AND `begintime` 'timestamp2' LIMIT 0,1'; John W. Holmes wrote: I'm doing a select on a database that has about 45000 records and growing

Re: [PHP] DATE_FORMAT (MySQL function)

it in phpmyadmin and read the error if you get one. hope it helps, Maurits Lawende Mark Colvin wrote: I'm not sure if this is a php or mysql issue but I run the following query from a php script - $query = select d1.code, d1.type, d1.descr, d1.grouptype, d1.cusref, d1.stock, d1.minstock, d1.appmeth, d1