php-general | 2003022

RE: [PHP] MySQL Query Result Question From: Van Andel, Robbert (RVanAndel <email protected>)
Date: 02/28/03

Thanks to everyone who responded. I've figured it out. One of those ID 10 T errors. I was not clearing some necessary variables further down in the loop.

Robbert van Andel

-----Original Message-----
From: Van Andel, Robbert
Sent: Friday, February 28, 2003 3:57 PM
To: Ernest E Vogelsinger
Cc: php-general <email protected>
Subject: RE: [PHP] MySQL Query Result Question

I had the same thought and it didn't work. I have verified that $cmts[$i] is a different value then the previous iteration, but the second time through the same data as the first time through is processed. I've even run the actually query that I echoed onto the page through phpMyAdmin and verified that I got nothing back. I don't know at this point. I'm at a loss.

Robbert van Andel

-----Original Message-----
From: Ernest E Vogelsinger [mailto:ernest <email protected>]
Sent: Friday, February 28, 2003 3:51 PM
To: Van Andel, Robbert
Cc: php-general <email protected>
Subject: Re: [PHP] MySQL Query Result Question

At 00:20 01.03.2003, Van Andel, Robbert said:
--------------------[snip]--------------------
>I have the following query:
>$query = "SELECT d.utilization, d.capacity_date, d.day, i.id, i.interface,
>cd.date, cd.id ";
> $query .= "FROM (capacity_data as d LEFT JOIN interfaces as i ON
>d.interface = i.id) ";
> $query .= "LEFT JOIN capacity_date as cd ON d.capacity_date=cd.id ";
> $query .= "WHERE i.router = '$cmts[$i]' AND cd.date >= '$useDate' ";
> $query .= "ORDER BY i.interface,cd.date DESC";
>
>if(!$result = mysql_query($query)) die(mysql_error());
>
>while($data=mysql_fetch_array($query)
>{
> //SSLT
>}
--------------------[snip]--------------------

Simply setting $result=null after the loop should do, or am I off topic?

if(!$result = mysql_query($query)) die(mysql_error());
while($data=mysql_fetch_array($result))
{
   //SSLT
}
$result = null;
// could also use
// unset($result); 

-- 
   >O     Ernest E. Vogelsinger
   (\)    ICQ #13394035
    ^     http://www.vogelsinger.at/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php