RE: [PHP] MySQL Query Result Question

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@lists.php.net 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@vogelsinger.at] Sent: Friday, February 28, 2003 3:51 PM To: Van Andel, Robbert Cc: php-general@lists.php.net 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