/*
* 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);
};
?>
Array From SQL Result
# Field 01 Field 02 Field 03
$dbhost = "mysqlserver";
$dbuserlogin = "myname";
$dbpassword = "mypassword";
$dbname = "mydatabase";
$dbsql = "SELECT field1,field2,field3 FROM tables";
//-- by field index --
$myarray = nas_mysql_result
($dbhost,$dbuserlogin,$dbpassword,$dbname,$dbsql,"byindex");
for ($i=0; $i < count($myarray); $i++) {
echo "$i. ";
for ($j=0; $j < 3; $j++) {
echo "".$myarray[$i][$j]." ";
};
echo "
};
//-- by field name --
$myarray = nas_mysql_result
($dbhost,$dbuserlogin,$dbpassword,$dbname,$dbsql,"byname");
for ($i=0; $i < count($myarray); $i++) {
echo "$i. ".$myarray[$i]["field1"]." ".$myarray[$i]
["field3"]."
};
?>