How to put result set in array and close db connection

[ryland22]

I'm making the shift from asp to php and having trouble with one particular problem:

I want to query the dbase, then take the result set and put it into an array so that I can immediately close the connection to the dbase, thus saving on resources.

Lastly, I want to loop through the array viewing only data from a particular column of the array.

My question: The code below works fine, but I thought that mysql_fetch_assoc required an open connection to the dbase- can someone verify for me that I have effectively closed the connection to my dbase?

<?php
$host = "";
$uname="root";
$pass="";
$database="discuss";
$tablename="threads";
$connection = mysql_connect($host, $uname, $pass);
$result =mysql_select_db("discuss");
$query ="SeLECT * from threads where thread_num = $thread";
$result = mysql_query($query);
mysql_close($connection);
?> 

blah blah code code

<?php
//here comes my loop
mysql_data_seek($result,0);
while ($row = mysql_fetch_assoc($result))
{
echo "<tr><td>";
	{
	if ($row["new_thread"] == "yes")
	echo "<br>&nbsp;";
	}
echo "<img src=\"graphic".$row["sub_num"].".bmp\">";
echo "<a href=\"read_thread-" .$row["thread_num"]. "-" .$row["sub_num"]. ".html\">";
echo $row["topic"];
echo "</a>&nbsp;";
echo "<font size=\"-1\">$row[name]&nbsp;$row[date_time]</font>";
echo "</td></tr>";

}
?>

[azunoman]

Closing a connection isn't strictly necessary because they will be closed when a script finishes execution anyway. Maybe just good form...

I use the following function to build an array from all my database reads. Note: all my database actions are in functions, and they call the db

   

// Within some select DB function, only partil select function shown
$query ="SELECT * FROM some_tbl WHERE some_thing='some_thing'"; 
$result = @mysql_query($query);
$num_rows = @mysql_num_rows($result);  	
if ($num_rows==0)  	
{  		
     return false;   	
}else{
      $result = db_result_to_array($result);  	

}  

function db_result_to_array($result)  

{     

$res_array = array();      

 for ($count=0; $row = @mysql_fetch_array($result); $count++)
     $res_array[$count] = $row;     

return $res_array;  

}