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

2007-07-23 Thread Rob Adams
Oid limit {l1}, {l2} Here is the query. I didn't know that it needed to have an ORDER clause in it for the limit to work properly. I'll probably order by h.listdate -- Rob "Stut" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Chris wrote: Stut wrote:

[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 dec

[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: Favorite 1 Favorite 2 Then, in your PHP code, first check to see if there is more than one value: if (is_array($_POST["del"])) { // works only if id i