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 >> >> >gr

Re: [PHP] DATE_FORMAT (MySQL function)

f the code above doesn't work, try 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.