# Db =\> multidimensional Array

**URL:** https://forum.kirupa.com/t/db-multidimensional-array/12004
**Category:** Uncategorized
**Created:** [January 25, 2003, 1:54am UTC](https://forum.kirupa.com/t/db-multidimensional-array/12004 "2003-01-25T01:54:37Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Jubba](https://avatars.discourse-cdn.com/v4/letter/j/90ced4/32.png) [@Jubba](https://forum.kirupa.com/u/Jubba)
#### Post date: [January 25, 2003, 1:54am UTC](https://forum.kirupa.com/t/db-multidimensional-array/12004/1 "2003-01-25T01:54:37Z")

</div>

I would like to take my information from my db query and convert it into a mulitdimensional array. Not sure if its even possible…

Code:

```php

<? 
$userID = mysql_connect("localhost", "userName", "userPass"); 
mysql_select_db("dbName", $linkID); 

$resultID = mysql_query("SELECT nID, nText, nLink, nTarget FROM links", $userID); 

for($x= 0; $x < mysql_num_rows($resultID); $x++) 
{ 
   $row = mysql_fetch_assoc($resultID); 
   $nOuter = array( 
            $nInner[$x] = array("nText" => $row[nText], "nLink" => $row[nLink], "nTarget" => $row[nTarget]); 
            ) 
} 

print $nOuter[0][nText]; 
?> 

```

Parse error: parse error, expecting `’)’’ on line 11

Cheers,

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [January 25, 2003, 8:32pm UTC](https://forum.kirupa.com/t/db-multidimensional-array/12004/2 "2003-01-25T20:32:52Z")

</div>

I fixed my problem. Its not really the way I wanted to go, but it will probably turn out to be more useful.

```php

<?
$linkID = mysql_connect("localhost", "userName", "userPass");
mysql_select_db("dbName", $linkID);

$resultID = mysql_query("SELECT nID, nText, nLink, nTarget FROM links", $linkID);

$nTextA = array();
$nLinkA = array();
$nTargetA = array();

for($x= 0; $x < mysql_num_rows($resultID); $x++)
{
	$row = mysql_fetch_assoc($resultID);
	array_push($nTextA, "\"nText\" => $row[nText]");
	array_push($nLinkA, "\"nLink\" => $row[nLink]");
	array_push($nTargetA, "\"nTarget\" => $row[nTarget]");
}

print $nTextA[2]."<br>";
print $nLinkA[1]."<br>";
print $nTargetA[0]."<br>";

?>

```