Re: [PHP-DB] Slooooow query in MySQL.

2007-07-23 Thread Rob Adams
probably order by h.listdate -- Rob Stut [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Chris wrote: Stut wrote: Chris wrote: Rob Adams wrote: I have a query that I run using mysql that returns about 60,000 plus rows. It's been so large that I've just been testing it with a limit

[PHP-DB] Slooooow query in MySQL.

2007-07-19 Thread Rob Adams
I have a query that I run using mysql that returns about 60,000 plus rows. It's been so large that I've just been testing it with a limit 0, 1 (ten thousand) on the query. That used to take about 10 minutes to run, including processing time in PHP which spits out xml from the query. I

[PHP-DB] Re: check boxes and php

2003-03-27 Thread Rob Adams
The trick here is to use the right HTML field name and PHP syntax to receive the information. For your checkboxes in HTML, name them like this: input type=checkbox name=del[] value=1Favorite 1/input input type=checkbox name=del[] value=2Favorite 2/input Then, in your PHP code, first check to