Re: 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/