Create an Array from SQL Result
<?
/*
* nas_mysql_result — connect to mysql then load query result
* into a two dimensional array.
* —–
*/
function nas_mysql_result($dbhost,$dbuserlogin,$dbpassword,$dbname,$dbsql,$rstype) {
$dbconn = mysql_connect($dbhost,$dbuserlogin,$dbpassword) or die(“Server
Unavailable”);
mysql_select_db($dbname,$dbconn) or die(“Database Unavailable”);
$result = mysql_query($dbsql) or die(“Query Unavailable”);
//– initial value –
$iRows = 0;
$iCols = 0;
$iRows = mysql_num_rows($result);
$iCols = mysql_num_fields($result);
settype($arrContents,”array”);
switch ($rstype) {
case “byindex”:
for($row=0; $row<$iRows; $row++){
$rs = mysql_fetch_row($result);
for($col=0; $col<$iCols; $col++){
$arrContents[$row][$col] = $rs[$col];
};
};
return $arrContents;
break;
case “byname”:
for($row=0; $row<$iRows; $row++){
$rs = mysql_fetch_row($result);
for($col=0; $col<$iCols; $col++){
$arrContents[$row][mysql_field_name($result,$col)] = $rs[$col];
};
};
return $arrContents;
break;
};
mysql_free_result($result);
mysql_close($dbconn);
};
?>
