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
